List:General Discussion« Previous MessageNext Message »
From:Sebastian Mendel Date:March 10 2008 12:54pm
Subject:Re: MYSQL FUNCTIONS
View as plain text  
Krishna Chandra Prajapati schrieb:
> Hi All,
> 
> While i was going through mysql reference manual. I saw that
> 
> "A query cannot be cached if it contains any of the functions shown below"
> BENCHMARK()
> CONNECTION_ID()                              CONVERT_TZ()
> CURDATE()
> CURRENT_DATE()                               CURRENT_TIME()
> CURRENT_TIMESTAMP()
> CURTIME()                                    DATABASE()
> ENCRYPT() with one parameter
> FOUND_ROWS()                                 GET_LOCK()
> LAST_INSERT_ID()
> LOAD_FILE()                                  MASTER_POS_WAIT()
> NOW()
> RAND()                                       RELEASE_LOCK()
> 
> UNIX_TIMESTAMP() with no paramet-
> SLEEP()
> SYSDATE()                             USER()
> 
> On my production server, the following query is being used.
> select * from student where regis_date=now();
> Then what should i do so that the query get cached.

this would be like a time service would record once the current time, and 
than always just send this recorded time ... wired, not?

-- 
Sebastian
Thread
MYSQL FUNCTIONSKrishna Chandra Prajapati10 Mar
  • Select StatementVelen10 Mar
    • Re: Select StatementSebastian Mendel10 Mar
    • Re: Select StatementSebastian Mendel12 Mar
  • Re: MYSQL FUNCTIONSSebastian Mendel10 Mar
  • Re: MYSQL FUNCTIONSTim McDaniel10 Mar
Re: Select StatementVelen10 Mar
  • Re: Select StatementPeter Brawley10 Mar
    • Re: Select StatementBaron Schwartz10 Mar