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 ?

Reply via email to