auto incriment

[mbvo]

I'm trying to display data that no one field is required to be unique, so I want to make an automatic field that contains a number.  but there's no auto incriment data type for sql.  what do i do?

[obsidian]

auto increment is not a datatype but rather an attribute. if you're wanting an auto incrementing column, just set it up in your create table statement like this:
[code]
CREATE TABLE myTable (
  id int(11) auto_increment primary key
  -- continue your table on here --
[/code]

[fenway]

And you should make it UNSIGNED.