Add auto_increment to primary key in SQL

Question

I have table named A with column B defined int not null Primary Key and there are 4-5 foreign keys that point to this column already. With what syntax of Alter to make this primary key column be AUTO_INCREMENT ?

you asked just once faced task? http://stackoverflow.com/questions/2169080/mysql-alter-a-column-to-be-auto-increment — Sergey Vedernikov, Feb 18 '11 at 09:17

score 1 · Answer 1 · answered Feb 18 '11 at 09:18

1

Hi does something like this work?

alter table A B int NOT NULL AUTO_INCREMENT

I believe you should use something similar, if you use SQLYog to do it with the user interface then you see in the history tab the corresponding alter command generated.

answered Feb 18 '11 at 09:18

Davide Piras

43,984
10
98
147

Ultor is right, see the proper solution in the question he has posted above. – Davide Piras Feb 18 '11 at 09:20

score 1 · Answer 2 · answered Feb 18 '11 at 09:21

If its a primary column go to the table defination, there u can set the auto increment value in the column properties. go to the Column Properties ----> click on identity Specification -----> give the identity increment value and the identity seed value. then for every new row the value will be auto incremented.

score 1 · Accepted Answer · answered Mar 10 '11 at 05:22

1

ALTER TABLE A AUTO_INCREMENT=1

answered Mar 10 '11 at 05:22

NT88

947
5
25

Add auto_increment to primary key in SQL

3 Answers3