Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- From phpmyadmin -> Query SQL
- Insert the following code:
- <code>
- LOAD DATA LOCAL INFILE 'C:\\xampp\\mysql\\data\\segnoprogetto_calligaris_sofas\\Tab_Prezzi_Divani.csv'
- INTO TABLE `Tab_Prezzi_Divani` CHARACTER SET 'utf8'
- FIELDS TERMINATED BY ';'
- ENCLOSED BY ''
- LINES TERMINATED BY '\r\n'
- IGNORE 1 LINES;
- </code>
Add Comment
Please, Sign In to add comment