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, Link to comment https://forums.phpfreaks.com/topic/105055-solved-table-structure-problem-wont-execute-query/ 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`; Link to comment https://forums.phpfreaks.com/topic/105055-solved-table-structure-problem-wont-execute-query/#findComment-537770 Share on other sites More sharing options...
BrianM Posted May 10, 2008 Author Share Posted May 10, 2008 Thank you, this fixed my problem! Link to comment https://forums.phpfreaks.com/topic/105055-solved-table-structure-problem-wont-execute-query/#findComment-537778 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.