MySQL in HP-UX, how to populate an INT Field with ROWNUM/RECORDID Values?

[Alzhy]

I added a INT column named KNBO to an existing populated TABLE. I want to set the value/contents of the filed KBNO to be the record number or rowid.

How do I?


Many thanks!

[Laurent Laperrousaz · Accepted solution]

to add a field as a rownum, it just has to be auto_increment in the definition. So change your field definition

ALTER TABLE `TABLE` CHANGE `KNBO ` INT NOT NULL AUTO_INCREMENT PRIMARY KEY

That's it!

The field has to be the primary key

Hope this helps!

[Jean-Luc Oudart]

Nelson,

see example at :
http://dev.mysql.com/doc/mysql/en/example-auto-increment.html

Regards
Jean-Luc