Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> mysql problem help

mysql problem help

From: logia <logia123_at_netscape.net>
Date: Tue, 06 May 2003 18:16:47 GMT
Message-ID: <3EB7FDDB.8D850172@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 Tue May 06 2003 - 13:16:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US