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"
> CONNECTION_ID() CONVERT_TZ()
> CURRENT_DATE() CURRENT_TIME()
> CURTIME() DATABASE()
> ENCRYPT() with one parameter
> FOUND_ROWS() GET_LOCK()
> LOAD_FILE() MASTER_POS_WAIT()
> RAND() RELEASE_LOCK()
> UNIX_TIMESTAMP() with no paramet-
> 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?