The DELETE FROM statement is used delete rows from a database table.
DELETE FROM语句是用来从数据库表中删除记录行的。

Delete Data In a Database
删除一个数据库中的数据

The DELETE FROM statement is used to delete records from a database table.
DELETE FROM语句是用来从数据库表中删除记录行的。

Syntax
语法

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数据库连接建立的请求和指令的。

Example
案例

Earlier in the tutorial we created a table named "Person". Here is how it looks:
我们原先创建过一张名为“Person”的表文件，具体如下：

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”表如下：

MySQL 记录更新 PHP ODBC

评论 (0) All