SQL语句中常用的三个删除操作:
删除表结构及内容
DROP TABLE tableName;
清空表内容
TRUNCATE TABLE tableName;
删除表记录
DELETE FROM tableName WHERE columnName='values''
SQL语句中常用的三个删除操作:
DROP TABLE tableName;
TRUNCATE TABLE tableName;
DELETE FROM tableName WHERE columnName='values''
本文标题:SQL语句中的 drop truncate delete
本文链接:https://www.haomeiwen.com/subject/jiyjextx.html
网友评论