一、DELETE语句的基本用法
DELETE语句用于删除表中的记录。
DELETE语句语法:
DELETE FROM 表名 WHERE 条件语句;
演示student表:
删除student表最后一行数据,例:
DELETE FROM student WHERE student_number = 20190207;
运行结果:
注意!!使用DELETE语句时,如果没有加WHERE字句时,将会删除整个表的数据,例:
DELETE FROM student;
运行结果:
DELETE语句用于删除表中的记录。
DELETE语句语法:
DELETE FROM 表名 WHERE 条件语句;
演示student表:
删除student表最后一行数据,例:
DELETE FROM student WHERE student_number = 20190207;
运行结果:
注意!!使用DELETE语句时,如果没有加WHERE字句时,将会删除整个表的数据,例:
DELETE FROM student;
运行结果: