使用mysqldump跳过某些列的“field”

CREATE TABLE temp_table AS SELECT column1, column2, column3 FROM original_table;

mysqldump -u username -p database_name temp_table > backup.sql

DROP TABLE temp_table;

SELECT column1, column2, column3 INTO OUTFILE '/path/to/output.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
FROM original_table;

CREATE TABLE new_table LIKE original_table;
ALTER TABLE new_table DROP COLUMN column_to_skip;
LOAD DATA INFILE '/path/to/output.csv'
INTO TABLE new_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATE BY '
';