Update multiple tables

[pflakes]

I have multiple tables with the same column and would like to update the value in all of them as efficiently as possible. I am writing this into a procedure but for ease of reading here's the idea behind what I would like. Is there a way to do something like this?

update table1, table2, table3
set report_name = 'new'
where report_name = 'old'

 

[SantaMufasa]

PFlakes,

Wouldn't that be nice? But, alas, only a Christmas wish I fear. One must do it the old-fashioned way...one table at a time. Unless, of course, you have a properly normalised database where the "same data" resides in one table rather than "many tables" .

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:14 (15Dec04) UTC (aka "GMT" and "Zulu"),
@ 10:14 (15Dec04) Mountain Time