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 ?