Monthly Archives: January 2012

Date time format setting to current date

Advertisements

Reading in a *.csv file and loading the data into an Array

http://www.daniweb.com/software-development/java/threads/17262 for reading file local disk
http://www.daniweb.com/software-development/java/threads/84370 for downloading a file
http://forums.mysql.com/read.php?79,1505,1505 for file importing into my sql db
LOAD DATA LOCAL INFILE ‘c:\\site.txt’ INTO TABLE `hikes` FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ ESCAPED BY ‘\\’ LINES TERMINATED BY ‘\r\n’ 


http://dev.mysql.com/doc/refman/5.5/en/load-data.html for import file details

file importing to my sql db through java

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’ 

%d bloggers like this: