MYSQL database connectivity through c# application

Question

Hi.. I m Connecting to mysql using c#.I want to get last inserted id.I want to use that last inserted id+1 when next time i will run application.. But whenever i will run my application get id 1 everytime.. Thanks..

Jignesh Trivedi · Answer

hi how you get last inserted id from table? i thing LAST_INSERT_ID() function can help you on same Please refer http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id hope this will help you.