|
|
|
| Syntactic Confectionery Delight | |
| PerlMonks |
Re: getting the ids of records affected by an input statementby grantm (Parson) |
| on Nov 22, 2010 at 22:16 UTC ( [id://873061]=note: print w/replies, xml ) | Need Help?? |
|
The SQL spec allows an UPDATE statement to have a 'RETURNING' clause, which will (I think) do exactly what you want. Unfortunately it's not implemented in MySQL. It's been in Postgres since version 8.2 and is documented here.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||