How to add index that auto-increases

[dickreuter]

I'd like to set up a table that has a column ID which is automatically increased by 1 with each entry I make into this talble. What's the best way of doing this?

many thanks
Nicolas

[NogDog]

Depends on the DBMS you are using. If using MySQL: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html