auto increment problem

[expired user #10619]'s profile image [expired user #10619] posted 7 years ago in General Permalink

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's profile image kalvaro posted 7 years ago Permalink

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

[expired user #1502]'s profile image [expired user #1502] posted 7 years ago Permalink

Id column must be primary key

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