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