MySQL - Counter type field...

komodosp · 2012-02-28 12:35:02

Hi folks Is this possible in SQL? - I have a table with a column called "Position" Currently this value is all zeroes. But I want to populate this field with a sequence of numbers starting at 1 and counting up... i.e. first record will have position = 1 second record will have position = 2, etc. Thanks!

28-02-2012 01:35PM

#1

komodosp

Registered Users, Registered Users 2 Posts: 1,657 ✭✭✭

Join Date: December 2006

Posts: 1435

Hi folks

Is this possible in SQL? - I have a table with a column called "Position" Currently this value is all zeroes.
But I want to populate this field with a sequence of numbers starting at 1 and counting up...

i.e. first record will have position = 1
second record will have position = 2, etc.

Thanks!

0

Comments

#2 28-02-2012 01:38PM

komodosp

Registered Users, Registered Users 2 Posts: 1,657 ✭✭✭

Join Date: December 2006

Posts: 1435

OK thought of this as soon as I clicked Post, but I made it an index, changed it to AUTO_INCREMENT which automatically populated the field in the way I want, then removed it as an index and removed the AUTO_INCREMENT...

0