How can I retrieve the ID of the last record I added?

[Sandeep Gupta]

I'm using mxODBC on Linux to access MySQL and MSSQL.  I'm performing
inserts from within a transaction and need to get the value of the
auto-incremented column for the just inserted row.
Is there a method or select I could execute to get that value?

Thanks