Jump to content

[SOLVED] Table structure problem wont execute query


BrianM

Recommended Posts

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,

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.