Shulou(Shulou.com)05/31 Report--

This article introduces the knowledge of "SELECT / *! 40001 SQL_NO_CACHE * / * FROM Analysis in MySQL". In the operation of actual cases, many people will encounter such a dilemma. Next, let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

SELECT / *! 40001 SQL_NO_CACHE * / * FROM appears during backup

It's just an answer.

1 / *! * / this is the syntax of mysql Terry, not a comment, because the conditions are also executed.

2! This is followed by the version number, and if the database is equal to or greater than this version number, the code in the comment will also be executed.

3 then this sentence means that if the version number is greater than or equal to 4, sql_no_cache is executed, that is, there is no need to cache data. This is not to say that this query is not cached for the next query.

4 Mysql automatically invokes this syntax during the backup operation.

This is the end of the content of "SELECT / *! 40001 SQL_NO_CACHE * / * FROM Analysis in MySQL". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.