You will need to read up on mysql before you dig to far into this project. auto inc type columns will auto increment the value for new inserts this combined with defining the column as unique and indexing will give you what you want.