MySQL DELETE 语句删除单条，多条，所有

从命令行中删除数据

mysql> use RUNOOB;
Database changed
mysql> DELETE FROM runoob_tbl WHERE runoob_id=3;

使用 PHP 脚本删除数据

// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'DELETE FROM runoob_tbl
        WHERE runoob_id=3';

单条

删除 id 为 3 的行: delete from students where id=3;

多条

删除所有年龄小于 21 岁的数据: delete from students where age<20;

多条

删除表中的所有数据: delete from students;

文章来自 www.dgkunfu.com