I'm not clear what you're asking, but this is from a tutorial I wrote:
LOADING DATA INTO A TABLE from a text file
You can add data to a table by doing it one row at a time. This involves a lot of typing if you have many columns, and also prone to typing errors. An easier way is to put all your data into a text file, then tell mysql to load all the data at once.
But wait a minute, how does mysql know which info goes in which column if all the data is put in a single text file?
Well, what you do is
separate each data with a tab. When mysql encounters a tab, it knows that the next data goes into a new column,
separate each record with a return. When mysql encounters a new line, it knows that the next data goes into a new row.
Note: when entering your data into the text file, enter one record per line. So if you have 10,000 records for instance, you will enter them into a text file one record per line. You only press Enter at the end of each record.
Once all records have been entered, save the file into c:\mysql\data as file_name.txt. file_name can be any valid name you want. Now to populate your table with the data, issue the command
mysql> LOAD DATA INFILE "./file_name.txt" INTO TABLE db_name.table_name;
Change db_name to the name of your database, and table_name to the name of the table you want to add data to.
