Re: Creating table syntax error with mysql 5.0!
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 withou
Creating table syntax error with mysql 5.0!
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, ->