View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 11:29 AM
Good Man
 
Posts: n/a
Default Re: CREATE TABLE with 'table' and 'field' as Key names

Darek <darek@nowhere.nohow> wrote in news:fgflrf0205o@news1.newsguy.com:


> This database is for a hosted site, so I don't know if the key names
> are required, and I'm not really in a position to start renaming them.
>
> The same error pops up when I try the insert on 3.23.49 and I got this
> CREATE syntax from mysqldump, using '-c -a', '-c', '-a' and no switch
> at all.
>
> What can I do to troubleshoot this further?


Well, no point in troubleshooting it further because you know the problem:
MySQL has "Reserved Words" that your database is using. You'll have to
change your database.

http://dev.mysql.com/doc/refman/5.0/...ved-words.html

Reply With Quote