导入数据:
LOAD DATA INFILE 'c:/tmp/discounts.csv'
INTO TABLE discounts
FIELDS TERMINATED BY ',' #分隔符
ENCLOSED BY '"' #结尾符
LINES TERMINATED BY '\n' #换行
导出数据:
mysqldump -u [username] -p -t -T/path/to/directory [database] --fields-enclosed-by=\" --fields-terminated-by=,