Skip navigation links

MySQL Forums :: Newbie :: ERROR 1064 (42000): on simple insert


Advanced Search

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 Adam Levenstein 11/17/2007 02:24PM
Re: ERROR 1064 (42000): on simple insert marc castrovinci 11/17/2007 03:49PM
Re: ERROR 1064 (42000): on simple insert Guelphdad Lake 11/17/2007 04:46PM
Re: ERROR 1064 (42000): on simple insert Adam Levenstein 11/17/2007 10:23PM


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.