Do you just want to replace current value in client column to "NEW".
You can write a stored proc , with a cursor and loop through the cursor,
update each table.
On Mon, Apr 30, 2012 at 2:47 PM, Pothanaboyina Trimurthy <
> Hi all,
> i have one database with 120 tables and each table contains one
> common column that is "client" now i want to update all the tables
> column client = "NEW". is it possible to write a single query to
> update this one.
> please help me.
> thanks in advance
> Thanks & Kind Regards,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql