在SQL數(shù)據(jù)庫中備份表和恢復(fù)表可以使用以下方法:
備份表:
CREATE TABLE backup_table AS SELECT * FROM original_table;
SELECT * INTO OUTFILE 'backup_table.csv' FROM original_table;
恢復(fù)表:
INSERT INTO original_table SELECT * FROM backup_table;
LOAD DATA INFILE 'backup_table.csv' INTO TABLE original_table;