importing data into MYSQL

Hi does anyone have an example command line syntax command for
importing a delimited flat file with a delimiter into mysql ??

Also, does anyone have insight into this - I tried to use TOAD to
import, but there is this "String Quote Character" entry which does
not allow import of single quotes if you enter a single quote - does
anyone know what to put in this entry ? I tried { and it seemed to
work but this is a strange requirement.

Thank you,

Ben

On Jan 30, 11:10 am, "Jack" <jack_posem...@yahoo.com> wrote:
> Hi does anyone have an example command line syntax command for
> importing a delimited flat file with a delimiter into mysql ??

I usually import data using LOAD DATA INFILE. Here is the manual
entry:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html


> Also, does anyone have insight into this - I tried to use TOAD to
> import, but there is this "String Quote Character" entry which does
> not allow import of single quotes if you enter a single quote - does
> anyone know what to put in this entry ? I tried { and it seemed to
> work but this is a strange requirement.

Sorry... Don't know anything about TOAD, and I may be way off base,
but with single quotes, you can escape them with a / (forward slash?),
and they will be accepted into mysql.

Hope some of that helps,

Nino