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? stackoverflow.com/questions/2169080/… — Sergey Vedernikov
– Sergey Vedernikov, Commented Feb 18, 2011 at 9:17

NT88 · Accepted Answer · 2011-03-10 05:22:40Z

1

ALTER TABLE A AUTO_INCREMENT=1

answered Mar 10, 2011 at 5:22

NT88

9475 silver badges25 bronze badges

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

Comments

Davide Piras · Accepted Answer · 2011-02-18 09:18:37Z

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, 2011 at 9:18

Davide Piras

44.7k10 gold badges103 silver badges150 bronze badges

1 Comment

Davide Piras Over a year ago

Ultor is right, see the proper solution in the question he has posted above.

Sai Kalyan Kumar Akshinthala · Accepted Answer · 2011-02-18 09:21:43Z

1

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.

answered Feb 18, 2011 at 9:21

Sai Kalyan Kumar Akshinthala

11.9k8 gold badges45 silver badges68 bronze badges

Collectives™ on Stack Overflow

Add auto_increment to primary key in SQL

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related