[thelist] Question on importing textfile into mySql

[Dan Stetser]

Importing CSV's into MySQL are easy with:

MySQL Import

Import data into your MySQL database through a web browser.
http://www.itlab.musc.edu/toolbox.htm

Customized it for a client to update her online shopping cart by uploading
a CSV via a web browser. Works great.


At 12:17 PM 12/20/2000 -0500, Ari wrote:
>Hi. For my personal site at home, I recently bought a new domain so I can
>shift operations of one of my sites to this new domain, and I will be
>learning mySQL and PHP to do this effectively. Anyway, I just created the
>table last night with phpadminwizard and I was wondering how easy it is to
>import a textfile?
>
>If I use a message parsing program (which I have) to parse emails to a CSV
>file,
>can I then easily import that file into the table so I don't have to write
>it line by line?