Re: Creating table syntax error with mysql 5.0!

[Peter Brawley]

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