When issuing a statement to MySQL8 server:
SELECT SQL_NO_CACHE *
FROM ;
I get this warning:
Warning, 1681, 'SQL_NO_CACHE' is deprecated and will be removed in a
future release.
I would like to ask if there is any successor of the SQL_NO_CACHE that works or is planned to work with MySQL 8.x?
Does SQL_NO_CACHE actually work with MySQL 8.x or it is omitted by the server?
解决方案
Just noticed it, damn it was so useful -_-
Keep using it until it's removed or try SELECT column, now() FROM myTable instead.
I suppose the call will force mysql to not use the cache.