List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:April 30 2012 9:26am
Subject:Re: update query
View as plain text  
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.

regards
anandkl

On Mon, Apr 30, 2012 at 2:47 PM, Pothanaboyina Trimurthy <
skd.trimurthy@stripped> wrote:

> 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,
> Trimurthy.p
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

Thread
update queryPothanaboyina Trimurthy30 Apr
  • Re: update queryAnanda Kumar30 Apr
    • 回复: update queryZhangzhigang30 Apr
    • RE: update queryRick James30 Apr