Forum

MySQL - how to inse...
 
Notifications
Clear all

MySQL - how to inser huge data into table from CSV file?

1 Posty
1 Users
0 Reactions
1,440 Widok
0
Topic starter

using phpmyadmin genarates "memory limit" or "timeout"

1 Answer
0
Topic starter

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'

Odpowiedź

Author Name

Author Email

Your question *

 
Preview 0 Revisions Saved
Share: