i am making an applocation that allows users to download files from the app. the list of available downoads is generated from a mysql database. I don't really know much sql so i am asking for your help.

the table is setup like:

Table Name: programs

programid location programname programtype uploaded uploader

i dont know if i should make the download column an auto increment integer or what, and how would i add 1 to the current # in the row.