From: Pothanaboyina Trimurthy Date: April 30 2012 9:17am Subject: update query List-Archive: http://lists.mysql.com/mysql/227268 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 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