Question

SQL删除一行数据

SQL语句怎么写

Answer 1

delete from 数据表名
where 条件

Answer 2

delete from 数据库表名
where 条件

Answer 3

delete from table_name
where 条件

Answer 4

delete from 数据库表名
where 条件

例如：delete from test where id=1

Answer 5

delete from **表 where 后面加上条件

例如：
delete from 学生表 where 学号='123'

Answer 6

语法是
DELETE FROM 表名称 WHERE 列名称 = 值
例如从学生表中删除李敏的信息
DELETE FROM 学生表 WHERE name ="李敏"；
删除所有行的话
DELETE * FROM 表名称；
或DELETE FROM 表名称；