Import csv file to MYSQL

Posted by Bubbly under Others category on | Views : 4533
To import your csv data to Mysql table, which can be achieved by using load data in MySQL

Here a file will be created (here i have created tbltest.csv file) in C. tbltest is my table in Mysql
load data infile 'C:\\tbltest.csv' into table tbltest fields terminated by ',' enclosed by '"' lines terminated by '\r\n';

Comments or Responses

Login to post response