| 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 babin | 15 Nov |
| • Re: Creating table syntax error with mysql 5.0! | Peter Brawley | 15 Nov |
