MySQL如何要删除一个一行或者多行,用sql语句delete关键词,固定用法 delete from 表名。
1,delete删除一行
delete from student where id=1
2,delete删除多行
delete from student where in (1,2,3)
3,删除表的所有数据
delete from student
请使用不带where子句的delete语句
文章来自 http://www.dc3688.com
Copyright © 2009-2022 www.kswsj.com 成都快上网科技有限公司 版权所有 蜀ICP备19037934号