SQL Error when creating a table

Question

I have a problem when I run this SQL query:

 CREATE TABLE `softwaredb`.`profile`
    ( `id` INT(11) NOT NULL AUTO_INCREMENT ,
     `user_id` INT(11) NOT NULL ,
     `gender` VARCHAR(255) NOT NULL , 
    `height` INT(4) NOT NULL ,
     `weight` INT(4) NOT NULL ,
     `bodytype` INT(1) NOT NULL )

The error I keep running into is the following:

Incorrect table definition;
there can be only one auto column and it must be defined as a key

In the future, please add the tag of the specific database software you are using. — Colonel Thirty Two
– Colonel Thirty Two, Commented May 18, 2015 at 17:32

Sachu · Accepted Answer · 2015-05-18 17:35:02Z

1

Try this

CREATE TABLE `softwaredb`.`profile`
( `id` INT(11) NOT NULL AUTO_INCREMENT ,
 `user_id` INT(11) NOT NULL ,
 `gender` VARCHAR(255) NOT NULL , 
`height` INT(4) NOT NULL ,
 `weight` INT(4) NOT NULL ,
 `bodytype` INT(1) NOT NULL ,
primary key (id) //specify id as primary key will sort out the error..try
)

OR Try

CREATE TABLE `softwaredb`.`profile`
    ( `id` INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT ,
     `user_id` INT(11) NOT NULL ,
     `gender` VARCHAR(255) NOT NULL , 
    `height` INT(4) NOT NULL ,
     `weight` INT(4) NOT NULL ,
     `bodytype` INT(1) NOT NULL 
    )

edited May 18, 2015 at 17:35

answered May 18, 2015 at 17:31

Sachu

7,7549 gold badges59 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

SQL Error when creating a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related