List:General Discussion« Previous MessageNext Message »
From:jean claude babin Date:November 15 2008 8:00pm
Subject:Creating table syntax error with mysql 5.0!
View as plain text  
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 ?

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