Load csv into mysql from script

[tiburblium]

Was wondering if anyone has experience loading a csv into mysql via shell script? Just looking to do something pretty basic.

• Empty the table
• Load csv into said table

Values are comma seperated and enclosed in ", rows end with a return

I looked at the load function at mysql.com, but I didn't fully understand it... An example would be great =)

Thanks for any help!

[subwayman]

If you use phpmyadmin use that to try it out and look at the sql generated. It will give you the load syntax. It's one of the great things about phpmyadmin. Almost everything you do in it will let you see the sql used.