Posted By

veleta on 04/14/11


Tagged

sql files load


Versions (?)

SQL snippets


 / Published in: SQL
 

  1. # load cvs file
  2. LOAD DATA LOCAL INFILE '/home/esaenz/Desktop/CiratsApares/pipol.csv' \
  3. INTO TABLE people \
  4. FIELDS TERMINATED BY ',' (last_name, first_name, job_profile, userid, email, office_phone, cell_phone);
  5.  
  6. # empty table
  7. TRUNCATE TABLE `people`

Report this snippet  

You need to login to post a comment.