Read the manual section on "Is MySQL picky about reserved words?".
Your particular problem is even singled out as an example!
Tim
On Fri, May 14, 1999 at 05:49:56PM +1000, Kevin Waterson wrote:
> Tim Winders wrote:
>
> > You have to create the database with:
> >
> > create database users;
> >
> > Then you have to add the tables to the database with
> >
> > use users;
> > create table users_table(
> > etc etc
> >
>
> The first part worked great.. then
>
> mysql> use users
> Database changed
> mysql> create table users_table(
> -> username varchar (15),
> -> group varchar (15),
> -> name vachar (15),
> -> surname varchar (20));
> ERROR 1064: You have an error in your SQL syntax near 'group varchar (15),
> name vachar (15),
> surname varchar (20))' at line 3
> mysql> help
> now what am I doing wrong?
> It looks ok to my untrained eye
>
> again, thanksl
> Kevin
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread3348@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
>
