If condition in select query / insert /update

2009-05-17 Thread bharani kumar
Hi all , Can u give one example query , Which contain the IF condition , Because here before am not used the IF and all , Thanks -- உங்கள் நண்பன் பரணி குமார் Regards B.S.Bharanikumar POST YOUR OPINION http://bharanikumariyerphp.site88.net/bharanikumar/

Re: CentOS 4.4 mysqld crash

2009-05-17 Thread Joel Heenan
I have opened a bug about this issue: http://bugs.mysql.com/bug.php?id=44914 Joel On Tue, May 12, 2009 at 10:55 PM, Joel Heenan wrote: > Mysql List, > > I have a crash that has occured a number of times on a production CentOS > 4.4 machine. It occurs when using a product called Interspire Email

Re: Problem setting up slow logging in my,ini file

2009-05-17 Thread mos
At 01:22 PM 5/17/2009, Walter Heck - OlinData.com wrote: Try putting in a full existing pathname the server has write access to as opposed to just a file name. Walter Heck Walter, That didn't work either if I put it in the my.ini file. Without a path it should default the location to the

Re: xtrabackup

2009-05-17 Thread Baron Schwartz
Walt, I mentioned your question to Vadim Tkachenko who knows the most about it, and he suggested that it might be more appropriate to discuss on the percona-discuss...@googlegroups.com mailing list. Thanks, Baron On Fri, May 15, 2009 at 5:15 PM, Walt Weaver wrote: > Anyone using this? I'm looki

Re: Problem setting up slow logging in my,ini file

2009-05-17 Thread Walter Heck - OlinData.com
Try putting in a full existing pathname the server has write access to as opposed to just a file name. Walter Heck On Sun, May 17, 2009 at 12:13 PM, mos wrote: > I'm having a problem defining slow logging file in my.ini (Windows XP). I'm > using MySQL 5.1.30. > > In the MySQL reference manual

Problem setting up slow logging in my,ini file

2009-05-17 Thread mos
I'm having a problem defining slow logging file in my.ini (Windows XP). I'm using MySQL 5.1.30. In the MySQL reference manual it says: As of MySQL 5.1.29, the --log-slow-queries option is deprecated and will be removed (along with the log_slow_queries system variable) in MySQL 7.0. Instead, use

RE: Confused about syntax for specific join with 3 tables

2009-05-17 Thread abdulazeez alugo
> Date: Sat, 16 May 2009 15:39:56 -0700 > From: davidmichaelk...@gmail.com > To: mysql@lists.mysql.com > Subject: Confused about syntax for specific join with 3 tables > > I've been doing some experimenting with the data model from the "MySQL" > book (Addison Wesley). I have no trouble under

RE: how to add foreign key in alter command

2009-05-17 Thread abdulazeez alugo
> Date: Sun, 17 May 2009 14:25:55 +0800 > From: nathan.vorbei.t...@gmail.com > To: mysql@lists.mysql.com > Subject: how to add foreign key in alter command > > Hi guys > Please tell me the command syntax, how to add a colmmen foreign key in > alter syntax > thanks > Hello Nathan, Try