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.trimur...@gmail.com> 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 > >