Posted By

breign on 06/30/10


Tagged

mysql import file csv


Versions (?)

mysql query to populate table from data in file


 / Published in: SQL
 

  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  

You need to login to post a comment.