BrianM Posted May 10, 2008 Share Posted May 10, 2008 CREATE DATABASE `gamezero` CREATE TABLE `members` ( ID TINYINT NOT NULL AUTO_INCREMENT, firstName VARCHAR(60) NOT NULL, lastName VARCHAR(60) NOT NULL, email VARCHAR(60) NOT NULL, password VARCHAR(60) NOT NULL, gender VARCHAR(4) NOT NULL, PRIMARY KEY (ID) ); Here is the error I receive: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `members` ( ID TINYINT NOT NULL AUTO_INCREMENT, Quote Link to comment Share on other sites More sharing options...
mezise Posted May 10, 2008 Share Posted May 10, 2008 Hi, add semicolon at the and of command CREATE DATABASE `gamezero`; Quote Link to comment Share on other sites More sharing options...
BrianM Posted May 10, 2008 Author Share Posted May 10, 2008 Thank you, this fixed my problem! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.