Setting a column's datatype to autonumber

I have noticed that in Access RDBMS you are able to set the data-type of a column to autonumber which then automatically assigns a unique identifying number to each row. Is there an equivalent SQL command for a database such as mySQL?
ubya308Asked:
Who is Participating?
 
rickbus101Connect With a Mentor Commented:
Yes, it's the identity property with seed and increment values.

Here's the sql:

create table tablename
 (fieldname int identity (1, 10))

1 is the seed value and 10 is the increment value.

0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
If you want other UniqueIdentifier as datatype (that 128 byte long GUID), you may assign the Default value of the column to NEWID()

create table tablename
 (fieldname uniqueidentifier DEFAULT NEWID())
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.