Notes MySQL command delete from: Delete record

The delete from command is used to delete data from a table.

Delete from command format: Delete from table name where expression

For example, delete the record numbered 1 in table MyClass:
Mysql> Delete from MyClass where id=1;

Please compare the table changes before and after deleting the data.

Age

FirstName	LastName
Peter	Griffin	35
Glenn	Quagmire	33

The following is an example of PHP code to delete all Lastname= ' Griffin ' records in the "Persons" table:

2. <?php
4. $con = mysql_connect("localhost","Peter","abc123");
6. If (! $con){
8. Die(' Could not connect: ' . mysql_error());
10. }
12. mysql_select_db("my_db", $con);
14. Mysql_query("DELETE from Persons WHERE lastname= ' Griffin '"); mysql_close($con);
16. ?>

After this deletion, the table is like this:

Age

FirstName	LastName
Glenn	Quagmire	33

Notes MySQL command delete from: Delete record