删除语句:
1-删除表
DROP TABLE tablename;
2-删除表中全部数据
TRUNCATE TABLE tablename;
DELETE FROM tablename;
3-删除指定数据
DELETE FROM tablename WHERE 条件;
delete和truncate区别:
1-delete可恢复,truncate不可恢复
2-truncate更快
3-delete返回删除行数,truncate返回0,-1 成功/失败
删除语句:
1-删除表
DROP TABLE tablename;
2-删除表中全部数据
TRUNCATE TABLE tablename;
DELETE FROM tablename;
3-删除指定数据
DELETE FROM tablename WHERE 条件;
delete和truncate区别:
1-delete可恢复,truncate不可恢复
2-truncate更快
3-delete返回删除行数,truncate返回0,-1 成功/失败