Message: 2
Date: Wed, 16 Jul 2008 09:36:24 -0400
From: Daniel Barrett <danb(a)VistaPrint.com>
Subject: [Mediawiki-l] 2-table update using Database.php?
To: MediaWiki announcements and site admin list
<mediawiki-l(a)lists.wikimedia.org>
Message-ID:
<9445EBEE35E2D148921D2550399D1D3715CB321E(a)vpmail102.vistaprint.net>
Content-Type: text/plain; charset="us-ascii"
Is there a way to perform a two-table SQL Update statement using
functions in Database.php?
update table1, table2
set table1.x = table2.y
where table1.foo = table2.bar
Function Database.php::update() appears to accept only a single
table name. (This is in MW 1.12.)
Thanks.
DanB
mmm... this seems a SQL issue :-)
well, you can update joined table, but you must select the PK.
as example:
update (
select table1.id, table1.x as x, table2.id, table2.y as y
where table1.foo = table2.bar )
set x=y
G.
--
Giuseppe Briotti
g.briotti(a)mclink.it
"Alme Sol, curru nitido diem qui
promis et celas aliusque et idem
nasceris, possis nihil urbe Roma
visere maius."
(Orazio)