MYSQL Identity fields

[Anon]

Hey guys,

How Do I get MYSQL to return the identity of the last row I inserted?

for instance in M$ SQl Server you can do Insert int table(fields) Values(Values)
Select @@identity as cnt from table

How do you do that in MySQL???

[Anon]

If you are using an autoincrementing field:

Mysql manual:
http://www.mysql.com/doc/G/e/Getting_unique_ID.html

Cheers

[Anon]

Thanks!!! Man why is it always the easy things I cant find 🙂 Maybe I should read the manual 🙂