Skip to content

Instantly share code, notes, and snippets.

@allvee

allvee/File load into DB

Created October 8, 2017 06:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save allvee/93cd75c8753e6a81f6db5bfce97e2f02 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save allvee/93cd75c8753e6a81f6db5bfce97e2f02 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
File load into DB
LOAD DATA LOCAL INFILE 'E:/SDP_Status_Response_2017_10_07_PM.txt' INTO TABLE getsubscriptionstatus
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
(ActionTime, recordSum, msisdn, ShortCode, serviceID,productID,toState,channelID,SubscriptionTime);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment