社区微信群开通啦,扫一扫抢先加入社区官方微信群
社区微信群
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.
如果觉得我的文章对您有用,请随意打赏。你的支持将鼓励我继续创作!