Welcome Guest, Not a member yet? Register   Sign In
How to get id of last updated row
#4

[eluser]sv3tli0[/eluser]
Sorry, I misunderstand you.
There is no logical way to get affected ID.. It may be 0 , 1 or many..
Usually you update/delete using that id.. Perhaps you may catch it with select before updating..

Code:
SELECT id FROM table WHERE (updateWHEREcases)
and after it run the update..


Messages In This Thread
How to get id of last updated row - by El Forum - 08-11-2013, 12:36 AM
How to get id of last updated row - by El Forum - 08-11-2013, 05:48 AM
How to get id of last updated row - by El Forum - 08-11-2013, 06:04 AM
How to get id of last updated row - by El Forum - 08-11-2013, 06:52 AM
How to get id of last updated row - by El Forum - 08-11-2013, 03:28 PM



Theme © iAndrew 2016 - Forum software by © MyBB