Guest User

Untitled

a guest
Jan 20th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. From phpmyadmin -> Query SQL
  2. Insert the following code:
  3.  
  4. <code>
  5. LOAD DATA LOCAL INFILE 'C:\\xampp\\mysql\\data\\segnoprogetto_calligaris_sofas\\Tab_Prezzi_Divani.csv'
  6. INTO TABLE `Tab_Prezzi_Divani` CHARACTER SET 'utf8'
  7. FIELDS TERMINATED BY ';'
  8. ENCLOSED BY ''
  9. LINES TERMINATED BY '\r\n'
  10. IGNORE 1 LINES;
  11. </code>
Add Comment
Please, Sign In to add comment