Advanced Search

mysql query to populate table from data in file

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. ### LOAD DATA FROM FILE
  2. ### This IS working IN MySQL Query Browser ON Windows
  3. LOAD DATA LOCAL INFILE "C:\\Documents and Settings\\benjo\\Desktop\\keys.csv"
  4. INTO TABLE keys_allowed
  5. FIELDS TERMINATED BY ';'
  6. LINES TERMINATED BY '\n'
  7. (KEY, USER);
  8.  

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.