From: Peter Brawley
Date: November 15 2008 8:08pm
Subject: Re: Creating table syntax error with mysql 5.0!
List-Archive: http://lists.mysql.com/mysql/215230
Message-Id: <491F2C57.4020109@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------080006050606010101040900"

--------------080006050606010101040900
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

>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
>
>   

--------------080006050606010101040900--