I have a requirement like below.
In table I need to store id from the last insert id.
Suppose the last id column,
id is MD0004 , the next id should be MD0005.
I have a text box to take input like below
Based on quantity given in TextBox,
I have to insert that many records.
How to find the last id and how to increment that MD0004 to MD0005, MD0006,MD0007 so on..