MySQL - how to inser huge data into table from CSV file?« Wróć do listy pytań
using phpmyadmin genarates "memory limit" or "timeout"
|
▲ ▼ |
just type in console or phpmyadmin that command
LOAD DATA INFILE 'd:/my_data.csv' IGNORE INTO TABLE my_table_name FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n' |