当前位置: 首页 > 网络学院 > 服务端脚本教程 > PHP > MySQL 删除记录
The DELETE FROM statement is used delete rows from a database table.
DELETE FROM语句是用来从数据库表中删除记录行的。
The DELETE FROM statement is used to delete records from a database table.
DELETE FROM语句是用来从数据库表中删除记录行的。
DELETE FROM table_name WHERE column_name = some_value |
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.
在PHP内创建数据库,我们需要在mysql_query()函数内使用上述语句。这个函数是用来发送MySQL数据库连接建立的请求和指令的。
Earlier in the tutorial we created a table named "Person". Here is how it looks:
我们原先创建过一张名为“Person”的表文件,具体如下:
FirstName | LastName | Age |
---|---|---|
Peter | Griffin | 35 |
Glenn | Quagmire | 33 |
The following example deletes all the records in the "Person" table where LastName='Griffin':
在下面的案例中,我们从“Person”表中删除了LastName=’Griffin’的所有记录:
<?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='Griffin'"); mysql_close($con); ?> |
After the deletion, the table will look like this:
修改之后的“Person”表如下:
FirstName | LastName | Age |
---|---|---|
Glenn | Quagmire | 33 |