How to get auto_increment value from an MySQL insert query? - how to value a muecci pool cue
I have an INSERT statement that an entry in the database, which created the auto_increment "ID.
I want another query to the ID? or is there a better way to do this?
How To Value A Muecci Pool Cue How To Get Auto_increment Value From An MySQL Insert Query?
1 comments:
@ @ IDENTITY
Upon completion of an INSERT, SELECT INTO, or statement of bulk copy, @ @ IDENTITY, the last identity value for the classroom includes created.
SCOPE_IDENTITY () does the same work.
_
Post a Comment