List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:November 15 2008 8:08pm
Subject:Re: Creating table syntax error with mysql 5.0!
View as plain text  
>mysql> CREATE TABLE memberDetails
>       -> *(*
>       ->    memberId INT NOT NULL  AUTO_INCREMENT,
>       ->    PRIMARY KEY(memberId),
>       ->    first_name varchar(100),
>       ->    last_name varchar(100),
>       ->    Email varchar(60),
>       ->    phoneNum varchar(25)
>       -> *);*

Works without the asterisks.

PB

-----

jean claude babin wrote:
> I'm new with MySQL server 5.0 ,I tried to create a table MemberDetails from
> the mysql command shell,
>  I got an error 1064 (42000): *You have an error in your SQL syntax*;
>
> Here is my code:
> mysql> CREATE TABLE memberDetails
>        -> *(*
>        ->    memberId INT NOT NULL  AUTO_INCREMENT,
>        ->    PRIMARY KEY(memberId),
>        ->    first_name varchar(100),
>        ->    last_name varchar(100),
>        ->    Email varchar(60),
>        ->    phoneNum varchar(25)
>        -> *);*
>
> Any thoughts ?
>
>   
> ------------------------------------------------------------------------
>
>
> Internal Virus Database is out of date.
> Checked by AVG - http://www.avg.com 
> Version: 8.0.175 / Virus Database: 270.9.0/1777 - Release Date: 11/9/2008 9:53 AM
>
>   

Thread
Creating table syntax error with mysql 5.0!jean claude babin15 Nov
  • Re: Creating table syntax error with mysql 5.0!Peter Brawley15 Nov