Simple Method for deleting a record in mysql delete

The Simple Method for deleting a record in mysql is the simplest entry level. Let's take a look at how to delete a record using mysql SQL statements.

The Simple Method for deleting a record in the mysql tutorial is the simplest entry level. Let's take a look at how to delete a record using mysql SQL statements.

Mysql> delete from table name where id = 1;

Query OK,

In this way, you can delete it,

If you and php tutorial mysql configuration, you only need to use php to connect to the database tutorial and use php mysql_query ("delete from table name where id = 1"); then you can delete it.

<? 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 lastname = 'grigin '");

Mysql_close ($ con );
?>

Next, let's take a look at the mysql delete syntax.

Delete data from a database
The delete from statement is used to delete records from database tables.

Syntax

Delete from table_name
Where column_name = some_value

Note: SQL is case insensitive. Delete from is equivalent to delete from.

In order for php to execute the preceding statement, we must use mysql_query (function. This function is used to send queries and commands to SQL connections.