MySQL - how to inser huge data into table from CSV file?« Wróć do listy pytań

using phpmyadmin genarates "memory limit" or "timeout"
Wysłane przez mrmucha
Zadane przez 16/04/2018 09:46
▲
0
▼

just type in console or phpmyadmin that command

1
2
3
4

LOAD DATA INFILE 'd:/my_data.csv' IGNORE 
INTO TABLE my_table_name
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n'
LOAD DATA INFILE 'd:/my_data.csv' IGNORE 
INTO TABLE my_table_name
FIELDS TERMINATED BY ';' 
LINES TERMINATED BY '\n'
Wysłane przez mrmucha
Odpowiedziane 16/04/2018 09:47