update query

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

Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases.

hi every one Is there any performance difference, maintaining separate ibdata files for each and every table insted of having one singl tabale for all databases, for InnoDB Storage Engine. please let me know the difference. -- 3murthy -- MySQL General Mailing List For list archives: http://

Replication setup hep

Hi everyone i have 4 mysql servers out of those one server will be online always and the remaining will be offline and online. the operations takes place at the offline servers i want to replicate the data from the offline servers to the online server. for this can any one help me

ERROR : client option 'secure_auth' enabled

Hi guys, today i have installed mysql 5.6.13 tar binary distribution, on redhat5 machine. i have started the server with "skip-secure-auth", server started successfully. when i am trying to shutdown the server, it throwing the following error, can any one please let me know why it is h

Re: ERROR : client option 'secure_auth' enabled

Hi Reindl Harald, i have included [mysqladmin] section in config file also. but still facing same issue. On Mon, Sep 16, 2013 at 3:54 PM, Reindl Harald wrote: > > > Am 16.09.2013 12:14, schrieb Pothanaboyina Trimurthy: > > Hi guys, > > today i have installed my

Re: Remote Access to MySQL

and also make sure tcp port of your DB instance has been added to firewall expeption. check the iptables for this to verify. On Mon, Mar 9, 2015 at 2:13 PM, Florian Schaal wrote: > Am 08.03.2015 um 01:49 schrieb Rafael Ribeiro: > >> Hello List, >> >> >> I'm not an expertise on MySQL and we are

Issue with timestamp columns while working with MySQL load data in file

Hi All, I am facing an issue with timestamp columns while working with MySQL load data in file, I am loading around a million records which is taking around 2 hours to complete the load data. Before get into more details about the problem, first let me share the table structure. CREATE TABLE `te

Re: create_time

Hi Martin, which table are you looking at from information_schema? TABLES table should give you the correct information based on CREATE_TIME column, also if you check for show table status like 'table_name'; gives you the right information. On Fri, May 1, 2015 at 3:12 AM, Martin Mueller < martin

Re: create_time

hat was more or less identical with the > last update of the table. Which surprised me. > > From: Pothanaboyina Trimurthy skd.trimur...@gmail.com>> > Date: Friday, May 1, 2015 at 12:15 AM > To: Martin Mueller martinmuel...@northwestern.edu>> > Cc: "mysql@lis

Re: deleting big tables

Hi Pou, Before killing those connections first check for the undo log entries from the engine innodb status. If there are too many undo log entries it will take some time to clean up those entries. If you force fully kill those connections there are more chances to crash the DB instance. On 17 May

Re: Changing storage engine in dump file.

it is better to take the dump as it is on the master, restore it on the salve and then change the storage engine through alter table commands that will be the right way of doing and you could see any issues while converting from MyISAM to InnoDB. On Wed, Aug 12, 2015 at 6:51 PM, Johan De Meersman