Re: Selecting avg()...

In the last episode (Jan 06), Ashley M. Kirchner said: > >This is a continuation of something I started with a few weeks ago. > So, here's the previous information again: > > ++---+--+-+---++ > > | Field | Type

Re: Indexing issue in slave !!

In the last episode (Jan 06), Himanshu Raina said: > I am facing a peculiar problem.When i execute a query on slave server > it doesn't use indexes that have been created and hence read all the > records present in that table.The same query when execute on Master > yields proper results.The table s

Re: How to access an array variables in a single query

In the last episode (Jan 06), VenuGopal Papasani said: > On 1/6/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote: > >> I have got an array variable say a[]={"i1","i2",i3""} now i need > >> to get the values from the database that matches i1,i2,i3 for > >> example > >> > >> select * from tablename wh

Re: How to access an array variables in a single query

Hi, If the values to be matched against were from a table, why can't subquery be used. Like, SELECT * FROM TABLE1 WHERE id IN (select id from table2); Otherwise if numeric constants, then AFAIK procedure -loops would do. Thanks ViSolve DB Team. - Original Message - From: "VenuGopal

Re: On Duplicate Key Update question

Hi, From your query, understood that you want to retain old qty and new qty; result in another field. Try with, INSERT INTO TABLE1 (id,newqty) values (6,300) ON DUPLICATE KEY UPDATE totqty=oldqty+newqty, oldqty=newqty; Thanks, ViSolve DB Team - Original Message - From: "Ed Reed"

Selecting avg()...

This is a continuation of something I started with a few weeks ago. So, here's the previous information again: table: data ++---+--+-+---++ | Field | Type | Null | Key | Default | Ex

Indexing issue in slave !!

Hi, I am facing a peculiar problem.When i execute a query on slave server it doesn't use indexes that have been created and hence read all the records present in that table.The same query when execute on Master yields proper results.The table structure , table types are same.What could be wrong

Re: How to access an array variables in a single query

but that is not static for 3 variables what if array contains 1000 elements in cannot be used in such cases Thanks and Regards, venu On 1/6/07, ViSolve DB Team <[EMAIL PROTECTED]> wrote: Hi, IN operator will do. For Instance. SELECT * FROM TABLE1 WHERE id IN ('i1','i2','i3'); Thanks ViSol

Re: How to access an array variables in a single query

Hi, IN operator will do. For Instance. SELECT * FROM TABLE1 WHERE id IN ('i1','i2','i3'); Thanks ViSolve DB Team. - Original Message - From: "VenuGopal Papasani" <[EMAIL PROTECTED]> To: Cc: "bharath kumar" <[EMAIL PROTECTED]> Sent: Saturday, January 06, 2007 2:07 PM Subject: How t

How to access an array variables in a single query

Dear all, I have got an array variable say a[]={"i1","i2",i3""} now i need to get the values from the database that matches i1,i2,i3 for example select * from tablename where i1=a[1] and simillaryly to a[2] and a[3] but my list is too big one more option i can write it