备份单表策略

CREATE TABLE TABLE_NAME_20170222 LIKE TABLE_NAME;
INSERT INTO TABLE_NAME_20170222 SELECT * FROM TABLE_NAME

  

posted @ 2018-01-05 15:34  dingcx2013  阅读(79)  评论(0编辑  收藏  举报