delete删除行
1,删除某行
delete from 表名 where 列名称=列值
如:delete from n1
where name=0 或 where name is null
2,删除全部行
delete from 表名(类似与清空表,不改变表结构)
delete * from 表名
delete用法
最新推荐文章于 2024-07-26 13:46:56 发布
delete删除行
1,删除某行
delete from 表名 where 列名称=列值
如:delete from n1
where name=0 或 where name is null
2,删除全部行
delete from 表名(类似与清空表,不改变表结构)
delete * from 表名