Mysql add auto increment column

Question

I am trying to add column to a table in mysql with increment numbers, no matter if some of the rows would be deleted. For example:

id  name   surname  question/column
1   Peter  Peterson       1
5   Mike   Nikolson       2
11  Selena Selenson       3

The point is to get in every moment increment values, cause I need a list with numbers. Hope that is no big deal for much experiences database brains.

dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

Gordon Linoff
– Gordon Linoff

2015-01-03 13:51:34 +00:00
Commented Jan 3, 2015 at 13:51 — Gordon Linoff
– Gordon Linoff, Commented Jan 3, 2015 at 13:51
I can think of no sensible reason for storing this.

Strawberry
– Strawberry

2015-01-03 15:00:51 +00:00
Commented Jan 3, 2015 at 15:00 — Strawberry
– Strawberry, Commented Jan 3, 2015 at 15:00

Gordon Linoff · Accepted Answer · 2015-01-03 13:57:27Z

1

If you are trying to add an enumerated column to a result set, then use variables:

select jb, (@rn := @rn + 1) as seqnum
from justbrackets jb cross join
      (select @rn := 0) vars
order by id;

answered Jan 3, 2015 at 13:57

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Comment

user3572787 Over a year ago

I am trying to add column. If it is possible of course?

Collectives™ on Stack Overflow

Mysql add auto increment column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related