Your Ad Here

advanced code snippet search

Posted By

veleta on 04/14/11


Tagged

sql files load


Versions (?)

SQL snippets

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.