PHP MySQL Delete
DELETE statement to delete rows from a database table.
Delete data in the database
DELETE FROM statement is used to delete records from a database table.
grammar
DELETE FROM table_name WHERE some_column = some_value
Note: Please note that DELETE syntax WHERE clause.WHERE clause specifies which records need to be deleted. If you want to omit the WHERE clause, all records will be deleted!
To learn more about SQL knowledge, please visit our SQL tutorial .
To get PHP to execute the statement above we must use mysqli_query () function. This function is used to send a query or command MySQL connection.
Examples
Look at the following "Persons" table:
FirstName | LastName | Age |
---|---|---|
Peter | Griffin | 35 |
Glenn | Quagmire | 33 |
The following examples delete "Persons" table all LastName = 'Griffin' records:
<?php $con=mysqli_connect("localhost","username","password","database"); // 检测连接 if (mysqli_connect_errno()) { echo "连接失败: " . mysqli_connect_error(); } mysqli_query($con,"DELETE FROM Persons WHERE LastName='Griffin'"); mysqli_close($con); ?>
After this remove, "Persons" table is as follows:
FirstName | LastName | Age |
---|---|---|
Glenn | Quagmire | 33 |