一旦我们使用这个查询删除了记录，数据将无法恢复。因此，在从表中删除任何记录之前，建议创建数据库的备份。数据库备份允许我们在将来需要时恢复数据。
语法格式
DELETE FROM table_name
[WHERE Clause]
用命令行删除数据
DELETE 语句
mysql> use RUNOON;
Database changed
mysql> DELETE FROM runoon_tbl WHERE runoon_id=3;
Query OK, 1 row affected (0.23 sec)
LIMIT 子句
DELETE FROM table_name
WHERE condition
ORDER BY colm1, colm2, …
LIMIT row_count;
mysql> DELETE FROM runoon_tbl ORDER BY runoon_title LIMIT 3;
JOIN 子句
mysql> DELETE Employees, Payment FROM Employees
INNER JOIN Payment
ON Employees.emp_id = Payment.emp_id
WHERE Employees.emp_id = 102;
使用 PHP 脚本删除数据
MySQL DELETE 语句测试
<?php
$dbhost = 'localhost'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'DELETE FROM runoon_tbl
WHERE runoon_id=3';
mysqli_select_db( $conn, 'RUNOON' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法删除数据: ' . mysqli_error($conn));
}
echo '数据删除成功！';
mysqli_close($conn);
?>
mysql> SELECT * FROM runoon_tbl WHERE runoon_id=3;
+-----------+---------------+---------------+-----------------+
| runoon_id | runoon_title | runoon_author | submission_date |
+-----------+---------------+---------------+-----------------+
| 3 | 学习 Python | RUNOON.COM | 2016-05-06 |
+-----------+---------------+---------------+-----------------+
1 row in set (0.00 sec)
mysql> SELECT * FROM runoon_tbl WHERE runoon_id=3;
Empty set (0.00 sec)
本文地址：百科问答频道 https://www.neebe.cn/wenda/886510.html，易企推百科一个免费的知识分享平台，本站部分文章来网络分享，本着互联网分享的精神，如有涉及到您的权益，请联系我们删除，谢谢！
相关阅读
