Re: SQL: merging tables & preserving FKs

[Ash Berlin]

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