Load data from file.

  • Import data to mysql table from a csv file.

sample csv file: mo-ipad-itunes-prodID.csv
... .. .
com.mogeneration.ubmmedica.private.medicalobserver_,2014_01_31
com.mogeneration.ubmmedica.private.medicalobserver_,2014_02_07
com.mogeneration.ubmmedica.private.medicalobserver_,2014_02_14
com.mogeneration.ubmmedica.private.medicalobserver_,2014_02_21
com.mogeneration.ubmmedica.private.medicalobserver_,2014_02_28
.... .. ... ..
actual query:
LOAD DATA LOCAL INFILE 'mo-ipad-itunes-prodID.csv' 
INTO TABLE itunes_productid 
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(product_id_prefix, product_id_date) 
SET ID=NULL, name='', status=1;

- _

Add Comment

Sorry you must log in first to be able to add a comment. Click here to log in.
*/ ?>