[Mediawiki-l] 2-table update using Database.php?
Giuseppe Briotti
g.briotti at mclink.it
Thu Jul 17 12:01:22 UTC 2008
> Message: 2
> Date: Wed, 16 Jul 2008 09:36:24 -0400
> From: Daniel Barrett <danb at VistaPrint.com>
> Subject: [Mediawiki-l] 2-table update using Database.php?
> To: MediaWiki announcements and site admin list
> <mediawiki-l at lists.wikimedia.org>
> Message-ID:
> <9445EBEE35E2D148921D2550399D1D3715CB321E at 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 at mclink.it
"Alme Sol, curru nitido diem qui
promis et celas aliusque et idem
nasceris, possis nihil urbe Roma
visere maius."
(Orazio)
More information about the MediaWiki-l
mailing list