Skip to content

Instantly share code, notes, and snippets.

@bnsheehy

bnsheehy/Load_PnF_Table.sql

Last active December 26, 2021 22:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bnsheehy/2436720d402a085d9b35590251fd9564 to your computer and use it in GitHub Desktop.
Save bnsheehy/2436720d402a085d9b35590251fd9564 to your computer and use it in GitHub Desktop.
Download ZIP
Load the PnF Data History Table
Raw
Load_PnF_Table.sql
LOAD DATA LOCAL INFILE '/Users/....../data_files/df_pnf_data_history_complete_load.csv'
INTO TABLE price_data_historical
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
IGNORE 1 LINES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment