我们可以使用delete语句和where子句，来删除mysql表中的特定行。
示例mysql> select * from names;+------+-----------+| id | name |+------+-----------+| 1 | rahul || 2 | gaurav || 3 | raman || 4 | aarav || 5 | ram |+------+-----------+5 rows in set (0.00 sec)mysql> delete from names where id = 4;query ok, 1 row affected (0.07 sec)
上面的查询将从表 ‘names’ 中删除一个id = 4的行。
mysql> select * from names;+------+-----------+| id | name |+------+-----------+| 1 | rahul || 2 | gaurav || 3 | raman || 5 | ram |+------+-----------+4 rows in set (0.00 sec)
以上就是我们如何从mysql表中删除单行数据？的详细内容。