Insert data from a text file into the table

[afridy]

Hi. my websever mysql manager allows to Insert data from a text file into the table.
currently i have a table with the following fields.

email name country

so i wanto insers data from a text file into this table.
so my question is : how the text file format should be prepared.

i.e. the first record would be > [e-mail] john us

[adwatson]

Are you saying it has some sort of automated system to import tab delimited data or something? Or are you asking how to format the data into an SQL query for inserting the data?

[afridy]

hai adwat..

it has an automated syste. but adw. i found that the text file format should be in the follwoing order.

"[e-mail]","john","us"

Thank you for the post.
appriciate your continues support in the forum.

regards
afd.