-
What's wrong with this SQL?
I've been trying to create my tables the easy way by using phpMyAdmin. However, when I try to create a table, I get an error message. Here is the SQL phpMyAdmin is using:
CREATE TABLE 'quizzes' (
'qName' VARCHAR (32) NOT NULL ,
'qAuthor' VARCHAR (32) NOT NULL ,
'qIDnum' INT NOT NULL AUTO_INCREMENT ,
'qIDname' VARCHAR (16) NOT NULL ,
'qPass' VARCHAR (32) NOT NULL ,
'qMoreInfo' VARCHAR (255) NOT NULL ,
'qRandQuest' TINYINT NOT NULL ,
'qRandChoice' TINYINT NOT NULL ,
'qTimeLimit' INT NOT NULL ,
'qResultsOption' TINYINT NOT NULL ,
'qWordBankUsed' TINYINT NOT NULL ,
'qWordBankID' INT NOT NULL ,
'qQuestions' VARCHAR (32) NOT NULL ,
'qStudents' VARCHAR (32) NOT NULL ,
'qListNames' VARCHAR (32) NOT NULL ,
'qTypesName' TINYINT NOT NULL ,
PRIMARY KEY ('qIDnum') ,
UNIQUE (
'qIDname'
)
)
Why is this failing?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|