LOAD DATA local INFILE 'C:\\mysql_data_move\\xxx.csv' （导出csv文件的地址 注 第一个\ 为转义）INTO TABLE xxx(表名)CHARACTER SET UTF8FIELDSTERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY '\n'IGNORE 0 LINES ;...