MySQL DatabaseLesson 57Free preview

MySQL Database

This lesson is part of PHP · All levels

Summary

MySQL is a relational database management system (RDBMS) often paired with PHP to store data permanently. The data is compiled into a table of rows and columns, and then processed in SQL through the basic operations of CREATE, READ, UPDATE, and DELETE. PHP accesses MySQL through modern extensions such as mysqli and PDO.

Key points

MySQL stores data in a table containing rows and columns that are interrelated.
The basic operation is known as CRUD: Create, Read, Update, Delete.
SQL is used to create, modify, and retrieve data.
Modern PHP uses mysqli or PDO; the older mysql_ extension has been removed.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.