RE: Does MySQL have RETURNING in the language?

2008-10-16 Thread emierzwa
@lists.mysql.com Subject: Re: Does MySQL have RETURNING in the language? D. Dante Lorenso wrote: > There's an awesome feature that was added to PostgreSQL a while back > called RETURNING that allows you to make an INSERT, UPDATE, and DELETE > statement behave like a SELECT statement. > ...

Re: Does MySQL have RETURNING in the language?

2008-10-15 Thread Rob Wultsch
On Wed, Oct 15, 2008 at 2:09 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: >> Rob Wultsch wrote: >>> >>> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> >>> wrote: There's an awesome feature

Re: Does MySQL have RETURNING in the language?

2008-10-15 Thread D. Dante Lorenso
D. Dante Lorenso wrote: There's an awesome feature that was added to PostgreSQL a while back called RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement behave like a SELECT statement. ... Does RETURNING exist in any current release of MySQL or is it on the TODO list even?

Re: Does MySQL have RETURNING in the language?

2008-10-15 Thread Rob Wultsch
On Wed, Oct 15, 2008 at 2:00 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: > Rob Wultsch wrote: >> >> On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> >> wrote: >>> >>> There's an awesome feature that was added to PostgreSQL a while back >>> called >>> RETURNING that allows

Re: Does MySQL have RETURNING in the language?

2008-10-15 Thread D. Dante Lorenso
Rob Wultsch wrote: On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: There's an awesome feature that was added to PostgreSQL a while back called RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement behave like a SELECT statement. You can do somet

Re: Does MySQL have RETURNING in the language?

2008-10-15 Thread Rob Wultsch
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote: > There's an awesome feature that was added to PostgreSQL a while back called > RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement > behave like a SELECT statement. You can do something like this:

Does MySQL have RETURNING in the language?

2008-10-15 Thread D. Dante Lorenso
There's an awesome feature that was added to PostgreSQL a while back called RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement behave like a SELECT statement. You can do something like this: INSERT INTO mytable (id, value) VALUES (1, 'something') RETURNING any_colu