Alex Pukinskis writes:

> mysql> ALTER TABLE 'group' RENAME groups;
> ERROR 1064: You have an error in your SQL syntax near ''group' RENAME 
> groups' at line 1

It should be ` (backtick) rather than ' (apostrophe/single quote). This
is explained i the manual section on table/column names if I'm not
completely mistake (could very well be, tho).

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to