My Sql Return ID value after insert data in MySql?

Question

I am using MySql with classic asp. And i am inserting data in MySql Database.

I am Using this code to return ID when data is inserted. But it returns 0. so, is there any solution for return ID from MySql Database ?

Insert into table(name,lastname,username) Output Inserted.ID values("abc","def","ghi")

this returns value 0. So, how can i get ?

which programming language are you using? where is the front end code? — शेखर, Oct 10 '14 at 10:55
possible duplicate of [How to get the ID of INSERTed row in mysql?](http://stackoverflow.com/questions/7501464/how-to-get-the-id-of-inserted-row-in-mysql) — user692942, Oct 10 '14 at 11:19
I flagged the question as a duplicate ( and it is the answer proves it), maybe that's why it's been down-voted? — user692942, Oct 10 '14 at 13:53
but, i can't find that question. so, i asked on this site. If you have any problem then don't answer. — Nikunj, Oct 10 '14 at 13:57

score 1 · Accepted Answer · edited Oct 10 '14 at 11:17

1

edited Oct 10 '14 at 11:17

user692942

answered Oct 10 '14 at 10:56

शेखर

1 Answers1