The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. The file name must be given as a literal string.
I have already written the basic how to follow that considering additional cases.
A lot of questions I have seen for loading separated data to MySQL, so here [...]
Related posts:
- Load Delimited Data (csv, excel) into MySQL Server
- Using MySQLTuner – MySQL Optimization Tool
- MySQL related files and basic information
PlanetMySQL Voting:
Vote UP /
Vote DOWN