How do I create a column that automatically increments

[5amYan]

I need a value preferably Hex but int is fine that automagically increments with each new row.

I know this is simple but it will be my first database ever.

TIA
reed

5amYan
4.6692016090
-- Last line of authors current message --

 

[stoolpigeon]

You could make a column be 'serial'. This is an autoincrementing integer. If you want to make it hex- you would probably need to look at how serial is implemented and then roll your own with triggers or something- but I could be wrong there. But I would start by taking a look at serial and working from there.

 

[ceco]

use serial as stoolpigeon said and then when you fetch the value, just convert it to HEX