How do I import data into MySQL from a simple text file?
• If you have a plain text file that contains data, the LOAD DATA INFILE statement can be used to import it into MySQL. As an example, suppose that you have a text file called data.txt in the /tmp directory. Suppose further that within the file there is one record per line and that the fields of each are separated by a vertical bar. Below is what you might enter through the mysql client to import the data into the table table1 LOAD DATA INFILE ‘/tmp/data.txt’ INTO TABLE db1.table1 FIELDS TERMINATED BY ‘|’; The first line of this statement specifies the path and the name of the file to import. For a Windows server, the forward-slashes are still used for the file’s path, but a drive may need to be specified at the beginning of the path (e.g, ‘c:/tmp/prospects.txt’). The INTO TABLE clause specifies the database and the table to import into. The third line above specifies the vertical bar as the field delimiter. For some text files, you may need to specify the line terminator. If lines are
