1、备份表:create table T_BAK(备份表名) as select * from T(原表); 2、清除表内容: truncate table 表名; 转载于:https://www.cnblogs.com/zhao-zhao/p/10375175.html