Load from CSV into Database with renamed columns

[Glavin001]

See http://stackoverflow.com/a/13372912/2578205

[Glavin001]

I used http://www.sequelpro.com/ instead.

[Glavin001]

Having some trouble with the CALENDAR_DT field in sale table.

• Date imported from csv into mysql as 0000-00-00: http://stackoverflow.com/a/14560052/2578205
• MySQL STR_TO_DATE: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_str-to-date -MySQL DATE_FORMAT: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

[Glavin001]

Using Sequel Pro is working great. We will not be writing a SQL script to load.

Here was my work-in-progress script:

LOAD DATA LOCAL INFILE '~/Downloads/SobeysData/SALES_Header.csv' 
INTO TABLE `sale` 
LINES TERMINATED BY '\n'
(transactionRk, @calendarDt, `time`, itemSk, retailOutletLocationSk, @posTerminalNo, @cashierNo, itemQuantity, itemWeight, salesUOMCode, sellingRetailAmount, promoSalesCode, @stapleItemFlag, regionCode, customerSk)
SET `date` = STR_TO_DATE(@calendarDt, '%d%b%Y');