distal-attribute
distal-attribute
distal-attribute
distal-attribute

auto increment problem

EzyUser posted 1 month ago in General

Hi,

when trying to create a table with this line in the create statement

Id INT NOT NULL AUTO_INCREMENT,

I get a syntax error for the AUTO_INCREMENT.

same when trying to put 1 in auto increment field in options tab.

any idea why? how to overcome that?

thanks in advance

kalvaro posted 1 month ago

Are you talking about MySQL? Are you using HeidiSQL's table editor?

Misha v.3 posted 1 month ago

Id column must be primary key

Please login to leave a reply, or register at first.