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 I’ve created a very beginner level excel tool that will allow you to generate the LOAD DATA syntax as per your choices.
Presently sample table name and field/line separators are specified, which you may alter as per your own file.
Download the sheet here: Load Data
Load Data Syntax:
Options column specifies options that are required for syntaxes generation.
Under Selection column you will choose your option while under Description column, for each Option description is provided.
Using basic knowledge of load data you can quite easily generate the syntax by specifying option, choosing file to be loaded and finally clicking the Syntax button.
Please refer the syntax on MySQL documentation as well.
This is a “early release”, please check for the updates.
If you have any suggestions or bug report please comment / mail.