ChefDude

Anyone know how i retrieve an auto incrementing number in a SQL query

select [auto incrementing int], a,b from blah

1, a data, b data
2, a data, b data
3, a data, b data
4, a data, b data
...

I know i can create a column with an identity syntax, but i don't wanna.

Any ideas?

spectrum48k

here's my code for one of the MySQL dbases...

CREATE TABLE `test` (
`auto` int(11) NOT NULL auto_increment,
PRIMARY KEY (`auto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;