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;