Yes, group is a reserved word (think GROUP BY). See
http://www.mysql.com/doc/R/e/Reserved_words.html I believe you can make this work by putting the table name in quotes, e.g. Select * FROM 'group'; but you will probably find it easioer to rename your table. Michael On Wed, 5 Dec 2001, Alex Pukinskis wrote: > Whenever I try to do anything with a specific table in my db, I get an > error. Here's the list of tables: > > mysql> show tables; > +----------------+ > | Tables_in_acv2 | > +----------------+ > | company | > | group | > | internet | > | knowing | > | person | > | personality | > | stress | > | vision | > +----------------+ > 8 rows in set (0.01 sec) > > Some example errors: > > mysql> describe group; > ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 > mysql> select * from group; > ERROR 1064: You have an error in your SQL syntax near 'group' at line 1 > > I don't see any syntax error, though, unless "group" is some kind of > reserved word that I shouldn't use as a table name... I get this error > for _any operation on that table (check, repair, etc. as well). This > doesn't happen for any other tables: > > mysql> describe company; > +-------+-------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +-------+-------------+------+-----+---------+-------+ > | ID | int(11) | | | 0 | | > | name | varchar(30) | YES | | NULL | | > +-------+-------------+------+-----+---------+-------+ > 2 rows in set (0.01 sec) > > I'm using mysql-3.23.32 on Mac OS X Server 10.1.1. Thoughts? > > -Alex > > -- > Alex Pukinskis > Internet Consultant > aboutChange > http://aboutchange.com > http://aboutcreative.net > 303-444-0012 > f: 303-444-0015 > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
