I have a table like this
id path
1 image-1.jpg
2 image-2.jpg
5 image-5.jpg
9 image-9.jpg
I have deleted many last inserted row, I want to know the next increase id exactly will be inserted to set the path right like above!
Asked
Active
Viewed 54 times
-2
-
on very first time insert the data path as null and get the Id . after that you can update that specific row. – Deep Kakkar Feb 10 '17 at 05:31
1 Answers
0
You should achieve this in 2 steps.
- insert a record with path = '' and increment ID will be inserted
- in second step, get last inserted ID and then make path and update to that id.
Naveed Ramzan
- 3,565
- 3
- 25
- 30