insert into 报错

[dearalex]

初学MYSQL,碰到一条很简单的INSERT但老是报错,百思不得其解,特来求教
MYSQL是5.1
有一个表users,有Id,username,password,group,想添加一行,命令是:mysql> insert into users (Id,username,password,group) values (5,'test2','111','guest');

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 (5,'test2','111','guest')' at line 1
老是报语法错误,但网上查的结果...反正我看不出什么区别.

mysql> insert into users values (5,'test2','111','guest');
Query OK, 1 row affected (0.00 sec)
这样又可以了

求高手帮看看,谢谢了.

[wwwwb]

insert into users (`Id`,`username`,`password`,`group`) values (5,'test2','111','guest'); 不要用保留字做字段名

[dearalex]

保留字的问题啊... 我说这个错怎么莫名其妙,好像很低级的错误,呵呵 感谢!