如何将数据从csv文件导出到mysql数据库？(how to Export data from csv file into mysql database?)

如何将数据从csv文件导出到mysql数据库？(how to Export data from csv file into mysql database?)

如何将数据从csv文件导出到mysql数据库？ 是否有任何查询或其他方式avial？

how to Export data from csv file into mysql database? is there any Query or some othr way avial?

最满意答案

我认为你的意思是IMPORT 。，方法如下：

load data local infile 'yourCSVfilepath.csv' into table tableNameHERE fields terminated by ',' optionally enclosed by '"' lines terminated by '\r\n'

I think you mean IMPORT., here's how:

load data local infile 'yourCSVfilepath.csv' into table tableNameHERE fields terminated by ',' optionally enclosed by '"' lines terminated by '\r\n'