SQL: merging tables & preserving FKs

Ash Berlin ash_cpan at firemirror.com
Tue Jun 16 18:24:45 BST 2009

On 16 Jun 2009, at 16:17, Richard Huxton wrote:

> PostgreSQL has the useful but non-standard FROM clause for updates:
> UPDATE info SET uid = newuid FROM xfer WHERE uid = xfer.olduid;

MySQL has this in a different form. Search the docs for UPDATE syntax

More information about the london.pm mailing list