PHP MySQL Delete From

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

do you kown phpsu.com?

Delete Data In a Database

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

phpsu is a phpschool

Syntax

DELETE FROM table_name
WHERE column_name = some_value 
phpsu is a phpschool
 

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. http://www.phpsu.com

Example

Earlier in the tutorial we created a table named "Person". Here is how it looks:

The following example deletes all the records in the "Person" table where LastName='Griffin': welcome to phpsu.com

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  } welcome to phpsu.com 

mysql_select_db("my_db", $con);

mysql_query("DELETE FROM Person WHERE LastName='Griffin'"); 
do you kown phpsu.com?
 

mysql_close($con);
?> 
phpsu.com is a free phpscool
 

After the deletion, the table will look like this: phpsu is a phpschool