| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> mysql problem help
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, LogiaReceived on Tue May 06 2003 - 13:16:47 CDT
![]() |
![]() |