Re: UPDATE and simultaneous SELECT ... similar to RETURNING?

2009-12-25 Thread Baron Schwartz
Dante, On Tue, Dec 22, 2009 at 3:53 PM, Dante Lorenso wrote: > All, > > There was a feature of another DB that I have grown extremely accustomed to > and would like to find the equivalent in MySQL: > > UPDATE mytable SET > mycolumn = mycolumn + 1 > WHERE mykey = 'dante' > RETURNING mycolumn; I

UPDATE and simultaneous SELECT ... similar to RETURNING?

2009-12-22 Thread Dante Lorenso
All, There was a feature of another DB that I have grown extremely accustomed to and would like to find the equivalent in MySQL: UPDATE mytable SET mycolumn = mycolumn + 1 WHERE mykey = 'dante' RETURNING mycolumn; The magic of this statement is in the "RETURNING" clause. RETURNING causes ever