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
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