如何将csv导入mysql和mysql导出csv

2024-12-14 11:28:34
推荐回答(1个)
回答1:

操作步骤:

csv导入mysql

load data infile 'C:\\Users\\UserName\\Desktop\\test.csv'
into table `table`
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '\n';

mysql导入csv