I just want to have a table in which a first column is a monotonically increasing unique integer number. For example, if I have a table with 5 rows the indexes of the rows should be 1,2,3,4,5. And if I add a new row it gets index 6.
I am alway confused with this things because there are many related options: "auto_increment", "primary key", "unique", "index". What should I use?