Re: mysql problem help

Have you tried posting this question in comp.databases.mysql ? You might get a better response. This is comp.databases.theory.

cheers!

"logia" <logia123_at_netscape.net> wrote in message news:3EB7FDDB.8D850172_at_netscape.net...
> Hi there,
>
> I am quite new to mysql. I have tried mysqldump to do DB backup. A
> strange
> thing is that I can create table field name including space and "-".
> I can also dump the table without problem. But when I try to restore
> the dumped txt file by "mysql < db_backup.sql", it complains that
> "-" cause syntax error. It seems that either I change the name to
> remove "-" or I have to add "`" before "-". However these two
> solutions are
> all awkward. Anyone knows how to work around this easily?
> Thanks in advance!
>
> --
> BR,
> Logia
>
>
Received on Wed May 07 2003 - 08:56:25 CDT