PHP MySQL Delete from delete

Delete data from a database

The delete from statement is used to delete records from a database table.

Grammar

= Some_value

Note: SQL is not case sensitive. Delete from is equivalent to delete from.

In order for PHP to execute the above statement, we must use mysql_query (function. This function is used to send queries and commands to a SQL connection.

Example

Earlier, we created a table named "Persons" in this tutorial. It looks something like this:

The following example removes all Lastname= ' Griffin ' records from the "Persons" table:

<?PHP $con= Mysql_connect ("localhost","Peter","abc123"); if(!$con) {Die ('Could not connect:'. Mysql_error ()); } mysql_select_db ("my_db", $con); mysql_query ("DELETE from Persons WHERE lastname= ' Griffin '"); Mysql_close ($con);?>

After this deletion, the table is like this:

PHP MySQL Delete from delete