List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 14 1999 7:02am
Subject:Re: create database
View as plain text  
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.
> 
Thread
create databaseKevin Waterson14 May
  • Re: create databaseTim Winders14 May
    • Re: create databaseKevin Waterson14 May
      • Re: create databaseThimble Smith14 May
      • Re: create databaseTim Winders14 May
Re: create databaseBrian Hughes14 May