修改表名
alter table old_table_name rename to new_table_name;
删除表
(drop 最简单直接,一删除就全都没了)
drop table table_name;
truncate table table_name;
delete from table_name where column_name=values;
三者详细取别请见连接删除表的三种方法详解
alter table old_table_name rename to new_table_name;
(drop 最简单直接,一删除就全都没了)
drop table table_name;
truncate table table_name;
delete from table_name where column_name=values;
三者详细取别请见连接删除表的三种方法详解