mysql表备份

CREATE TABLE SYSM_CD_ALARM_SUBSCRIBE_RULE_WFD_0105 LIKE SYSM_CD_ALARM_SUBSCRIBE_RULE
INSERT INTO SYSM_CD_ALARM_SUBSCRIBE_RULE_WFD_0105 SELECT * FROM SYSM_CD_ALARM_SUBSCRIBE_RULE
SELECT * FROM SYSM_CD_ALARM_SUBSCRIBE_RULE_WFD_0105;      

1.仅仅复制表的结构

CREATE TABLE copy LIKE author;      

2.复制表的结构+数据

CREATE TABLE copy2
SELECT * FROM author;      

CREATE TABLE copy3
SELECT id,au_name
FROM author
WHERE nation='中国';      

CREATE TABLE copy4
SELECT id,au_name
FROM author
WHERE 0;