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 ?
