Monday, November 19, 2012
Import CSV File into MYSQL Query Browser :
Simple Query:
LOAD DATA LOCAL INFILE 'E:/123.csv' INTO TABLE documentupload FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
After that i used “select * from test_table”. The data are displayed
Simple Query:
LOAD DATA LOCAL INFILE 'E:/123.csv' INTO TABLE documentupload FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';
After that i used “select * from test_table”. The data are displayed
how to implement this using java
ReplyDelete