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
Paul Makepeace wrote:
OK SQL smarties,
I have two user tables, user and old_user, and a third table, let's say,
'info', that refers to old_user. I would like to merge/add users that are in
old_user to user and then update the info.old_user_id to their new
auto_increment'ed PKs in user.
My strate
On Wed, Jun 10, 2009 at 5:47 PM, Aaron Crane wrote:
>
> Paul Makepeace writes:
> > rpix:~$ perl -le 'print ord("À")'
> > 195
> >
> > What does 195 refer to? 195 is \xC3 which is another character,
> > according to http://jeppesn.dk/utf-8.html (A~ versus A`)
>
[snip detailed & useful answer]
Than
OK SQL smarties,
I have two user tables, user and old_user, and a third table, let's say,
'info', that refers to old_user. I would like to merge/add users that are in
old_user to user and then update the info.old_user_id to their new
auto_increment'ed PKs in user.
My strategy so far is to add a te
Let's have sushi to celebrate the fact that Edmund will be heading off
to Wales with his sheepies.
London.pm sushi is a social event where we meet up every Thursday at
12:15pm at a different Japanese restaurant, spend about an hour (and about
£15) eating tasty sushi (raw fish with rice), then go o