Home Yellow Pages Movies Classifieds Jokes Jobs Free Hosting Videos

MySQL Delete

Delete Data In a Database

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


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.


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':


$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'");


After the deletion, the table will look like this:

First Name Last Name Age
Nancy Varghese 33

Back to Home
BizHat.com   Bookmark   Astrology   Chat Room   Classifieds   Computer   Downloads   Directory   Dating   Domain Tools   Education   eCards   Finance   Forums   Freelance Work   Free Hosting   Free Mail   Gallery   Games   Guest Book   Greeting Cards   Ham Radio   Health   Home Business   Hosting Tutorials   Hosting Directory   India   Jobs   Jokes   Kerala   Matrimonial   Music   Movies   News   News Letter   Recipes   Real Estate   Search   SMS   Tourist Guide   Top 100 Sites   Vote Us   Yellow Pages   Arthunkal Church   Site Map