store timezone

2009-07-28 Thread Manoj Singh
Hi All, Is it possible to store the timezone with datetime data type in mysql or any other approach available to achieve this in mysql. Looking for your help. Thanks, Manoj

Re: Is Temporary table right approach

2009-04-16 Thread Manoj Singh
be boost so much if you can do something else to replace the temporary > table. > On Wed, Apr 15, 2009 at 2:03 PM, Manoj Singh wrote: > >> Hi All, >> >> I have a query which returns the large number of ids which i am using in >> other queries. I am doing this in PHP.

Is Temporary table right approach

2009-04-14 Thread Manoj Singh
Hi All, I have a query which returns the large number of ids which i am using in other queries. I am doing this in PHP. Now the first query can return unlimited number of ids which might create problem in PHP. I want to store this ids in MYSQL through temporary table so that i can access that ids