MySQL Delete
Delete Data In a Database
The DELETE FROM statement is used to delete records from a database table.
Syntax
DELETE FROM table_name WHERE column_name=some_value;
Note: SQL statements are not case sensitive. DELETE FROM is the same as delete from. To get PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.
Example
Earlier in the tutorial we created a table named "Person". Here is how it looks:
First Name |
Last Name |
Age |
Bill |
Gates |
36 |
Nancy |
Varghese |
33 |
The following example deletes all the records in the "Person" table where LastName='Gates':
<?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 person WHERE last_name='Gates'");
mysql_close($con);
?>
After the deletion, the table will look like this:
First Name |
Last Name |
Age |
Nancy |
Varghese |
33 |
Back to Home
|