Creating Table FAIL

Question

CREATE TABLE  `surfkid-db`.`Channels` (`name` VARCHAR( 30 ) NOT NULL ,`commercial` BOOL( 1 ) NOT NULL DEFAULT  '0' AUTO_INCREMENT ,`usrid` INT( 5 ) NOT NULL DEFAULT  '0' AUTO_INCREMENT ,`id` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE = MYISAM ;

Error:

#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 '(1) NOT NULL DEFAULT '0' AUTO_INCREMENT, `usrid` INT(5) NOT NULL DEFAULT '0' AUT' at line 1

I Couldn`t provide to error message, sorry please help

You might start with determining how, exactly, a BOOL value should be auto incremented.. — ChrisLively
– ChrisLively, Commented Oct 13, 2010 at 18:26

Thomas · Accepted Answer · 2010-10-13 18:26:52Z

4

I believe that only INTs can be AUTO_INCREMENT, and I'm fairly sure that only the primary key can be auto-incremented.

answered Oct 13, 2010 at 18:26

Thomas

5,0494 gold badges26 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jose Basilio · Accepted Answer · 2010-10-13 18:27:23Z

1

You don't need specify size for BIT and INT fields, also AUTO_INCREMENT does not apply to BOOL. Try this instead:

CREATE TABLE  `surfkid-db`.`Channels` 
(
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(30) NOT NULL ,
  `commercial` BOOL NOT NULL DEFAULT  0,
  `usrid` INT NOT NULL DEFAULT  0
)

answered Oct 13, 2010 at 18:27

Jose Basilio

51.7k13 gold badges124 silver badges117 bronze badges

Collectives™ on Stack Overflow

Creating Table FAIL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related