MySQL Forums
Forum List  »  Newbie

ERROR 1064 (42000): on simple insert
Posted by: Adam Levenstein
Date: November 17, 2007 02:24PM

I'm having a very strange issue, I hope y'all can help me with.

I'm working on a registration system, using MySql 5.0, for a local convention, and have a simple table to store various group names.

Here's the table layout:

mysql> describe groups;
+-------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| group | varchar(255) | NO | | | |
+-------+--------------+------+-----+---------+----------------+

However, when I try to do a simple insert:

mysql> insert into groups (group) values ('Some Group Name');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'group
) values ('Some Group Name')' at line 1


The table was generated by Propel, but is otherwise unremarkable and fairly simple.

The *really* strange part is that I have another table, with exactly the same layout (different names, of course), and it works just fine and dandy.

Any ideas?


Thanks,

Adam

Options: ReplyQuote


Subject
Written By
Posted
ERROR 1064 (42000): on simple insert
November 17, 2007 02:24PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.