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
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: