1、把表lianxi6,改名为lianxi3
alter table lianxi6 rename lianxi3
show tables
2、删除库lianxi6
drop database lianxi6
show databases
3、删除lianxi2表
drop table lianxi2
show tables
4、清空lianxi3表的数据
delete from lianxi3
1、把表lianxi6,改名为lianxi3
alter table lianxi6 rename lianxi3
show tables
2、删除库lianxi6
drop database lianxi6
show databases
3、删除lianxi2表
drop table lianxi2
show tables
4、清空lianxi3表的数据
delete from lianxi3