开发者

dumping csv file data into db through sql query

开发者 https://www.devze.com 2023-02-03 04:12 出处:网络
i have a .csv file containing a table data.I want to dump the total csv file into db using a query in mysql using column name as key...

i have a .csv file containing a table data.I want to dump the total csv file into db using a query in mysql using column name as key...

rather than doing it manually...like using "insert into" query...

if any other language like php or python program make this work...then also ok..开发者_开发技巧

can some one suggest me....pls


you can do this fairly easily with navicat software. more info here


load data local infile ...

LOAD DATA LOCAL INFILE '/tmp/your_file.csv' INTO TABLE your_table;

You need to ensure the mysql user has enough privileges to perform load

0

精彩评论

暂无评论...
验证码 换一张
取 消