hi,
could somebody tell me how sql_no_cache works. i tried using
SELECT SQL_NO_CACHE * FROM table where id='1'
but all i got was an error.
also, is it possible to set the mysql variables via php. something on the lines:
mysql_query("SET GLOBAL query_cache_type=0");
i have tried php.net and mysql's site, also searched google and its groups but all this to no avail. it seems that nobody uses this function.
thanx in advance