The DELETE statement is used to delete records in a table.
The DELETE FROM statement is used to delete records from a database table.
To learn more about SQL, please visit our SQL tutorial.
To get PHP to execute the statement above we must use the mysqli_query() function. This function is used to send a query or command to a MySQL connection.
Look at the following "Persons" table:
The following example deletes all the records in the "Persons" table where LastName='Griffin':
After the deletion, the table will look like this:
Your message has been sent to W3Schools.