video #38 - Advance PHP | SQL (Insert, Update, Delete)

In this video I am continuing the last PDO video. We will Insert, Update, and Delete a record from the database. I will be breaking this long video into several parts.

I am using the MySQL database which is an open-source relational database management system.

We are going to use SQL which stands for “Structured Query Language”. It is a domain-specific language used in programming and designed for managing data.

We will use INSERT, UPDATE, and DELETE commands to enable SQL users to manipulate and modify your data.

The INSERT statement introduces new rows into an existing table. The UPDATE statement modifies existing records with new data. The DELETE statement deletes records from a database. Once, you delete you can't get it back unless you perform a backup of your database.