![mysql-bin删除](https://i-blog.csdnimg.cn/blog_migrate/c4b38581d99dc26f20fffd765a5ca474.png)
mysql-bin删除
MySQL-删除查询 (MySQL - DELETE Query)
If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. You can use this command at the mysql> prompt as well as in any script like PHP.
如果要从任何MySQL表中删除记录,则可以使用SQL命令DELETE FROM 。 您可以在mysql>提示符以及任何脚本(如PHP)中使用此命令。
句法 (Syntax)
The following code block has a generic SQL syntax of the DELETE command to delete data from a MySQL table.
以下代码块具有DELETE命令的通用SQL语法,用于从MySQL表中删除数据。
DELETE FROM table_name [WHERE Clause]
If the WHERE clause is not specified, then all the records will be deleted from the given MySQL table.
如果未指定WHERE子句,则将从给定MySQL表中删除所有记录。
You can specify any condition using the WHERE clause.
您可以使用WHERE子句指定任何条件。
You can delete records in a single table at a time.
您可以一次删除单个表中的记录。
The WHERE clause is very useful when you want to delete selected rows in a table.
当您要删除表中的选定行时,WHERE子句非常有用。
从命令提示符中删除数据 (Deleting Data from the Command Prompt)
This will use the SQL DELETE command with the WHERE clause to delete selected data into the MySQL table – tutorials_tbl.
这将使用带有WHERE子句SQL DELETE命令将所选数据删除到MySQL表– tutorials_tbl中 。
例 (Example)
The following example will delete a record from the tutorial_tbl whose tutorial_id is 3.
以下示例将从tutorial_tbl中删除其tutorial_id为3的记录。
root@host# mysql -u root -p password;
Enter password:*******
mysql> use TUTORIALS;
Database changed
mysql> DELETE FROM tutorials_tbl WHERE tutorial_id=3;
Query OK, 1 row affected (0.23 sec)
mysql>
使用PHP脚本删除数据 (Deleting Data Using a PHP Script)
You can use the SQL DELETE command with or without the WHERE CLAUSE into the PHP function – mysql_query(). This function will execute the SQL command in the same way as it is executed at the mysql> prompt.
您可以在SQL函数mysql_query()中使用带有或不带有WHERE子句SQL DELETE命令。 该函数将以与在mysql>提示符下执行的相同方式执行SQL命令。
例 (Example)
Try the following example to delete a record from the tutorial_tbl whose tutorial_id is 3.
请尝试以下示例从tutorial_id为3的tutorial_tbl中删除一条记录。
<?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die('Could not connect: ' . mysql_error());
}
$sql = 'DELETE FROM tutorials_tbl WHERE tutorial_id = 3';
mysql_select_db('TUTORIALS');
$retval = mysql_query( $sql, $conn );
if(! $retval ) {
die('Could not delete data: ' . mysql_error());
}
echo "Deleted data successfully\n";
mysql_close($conn);
?>
翻译自: https://www.tutorialspoint.com/mysql/mysql-delete-query.htm
mysql-bin删除