mysql problem help
From: logia <logia123_at_netscape.net>
Date: Tue, 06 May 2003 18:16:47 GMT
Message-ID: <3EB7FDDB.8D850172_at_netscape.net>
Hi there,
Date: Tue, 06 May 2003 18:16:47 GMT
Message-ID: <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, LogiaReceived on Tue May 06 2003 - 20:16:47 CEST