MySQL如何要刪除一個一行或者多行,用sql語句delete關鍵詞,固定用法 delete from 表名。
1,delete刪除一行
delete from student where id=1
2,delete刪除多行
delete from student where in (1,2,3)
3,刪除表的所有數(shù)據(jù)
delete from student
請使用不帶where子句的delete語句
文章來自 http://www.dc3688.com