--更名 ALTER TABLE T_LOGSRV_SERVICE RENAME TO T_LOGSRV_SERVICE_20170418_BAK; --创建同样的表 CREATE TABLE T_LOGSRV_SERVICE AS SELECT * FROM T_LOGSRV_SERVICE_20170418_BAK WHERE 1=2;
--更名 ALTER TABLE T_LOGSRV_SERVICE RENAME TO T_LOGSRV_SERVICE_20170418_BAK; --创建同样的表 CREATE TABLE T_LOGSRV_SERVICE AS SELECT * FROM T_LOGSRV_SERVICE_20170418_BAK WHERE 1=2;
转载于:https://www.cnblogs.com/wuyechun/p/6728324.html