file importing to my sql db through java
LOAD DATA LOCAL INFILE 'c:\\site.txt' INTO TABLE `hikes` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
LOAD DATA LOCAL INFILE 'c:\\site.txt' INTO TABLE `hikes` FIELDS TERMINATED BY ';' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'
No comments:
Post a Comment