mysql中delete,drop和truncate的区别

显示所有数据库

show databses;
# 注意一定加s

切换数据库

use sys;

显示所有表

show tables;

mysql删除表的3种操作

drop

truncate

delete

############

drop

dorp table job;
# 删除后整张表将从库中消失

truncate

truncate table job;
表中job数据将被删除，重置自增列

delete

delete from job;
# 自增列记录会被保留，可以回滚
delete from job where id=1;
# 这样这个这个自增列记录会消失

设置停止自动提交

set autocommit=0;

delete from job where id=1;

rollback;
数据就可以回滚

DDL代表数据定义语言

create
drop
alter
truncate
rename
	rename table dept to dept1; #更改表名称
关键字是table

DML代表数据操作语言

insert
delete
update
select 
关键字是 from