How Can I Load Data From A Text File Into A Table?

1.	How Can I Load Data From A Text File Into A Table?
Answer» The MYSQL provides a LOAD DATA INFILE command. You can load data from a FILE. GREAT TOOL but you need to make sure that: a) Data must be delimited. b) Data fields must MATCH table columns correctly. The MySQL provides a LOAD DATA INFILE command. You can load data from a file. Great tool but you need to make sure that: a) Data must be delimited. b) Data fields must match table columns correctly.

Answer»

The MYSQL provides a LOAD DATA INFILE command. You can load data from a FILE.
GREAT TOOL but you need to make sure that:

a) Data must be delimited.
b) Data fields must MATCH table columns correctly.

The MySQL provides a LOAD DATA INFILE command. You can load data from a file.
Great tool but you need to make sure that:

a) Data must be delimited.
b) Data fields must match table columns correctly.

Discussion