1,当你不再需要该表时,用 drop
drop database student(删除数据库)
drop table student (删除整张表)
2,当你仍要保留该表,但是要删除所有记录时,用truncate
truncate table student(删除表内所有数据)
3,当你要删除部分记录时,用delete
delete from student where name=‘张三’
1,当你不再需要该表时,用 drop
drop database student(删除数据库)
drop table student (删除整张表)
2,当你仍要保留该表,但是要删除所有记录时,用truncate
truncate table student(删除表内所有数据)
3,当你要删除部分记录时,用delete
delete from student where name=‘张三’