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

This article mainly introduces the relevant knowledge of what the mysql analyzer is, the content is detailed and easy to understand, the operation is simple and fast, and has a certain reference value. I believe you will gain something after reading this mysql analyzer. Let's take a look at it.

Description

1. Write the sql according to the mysql grammar and give it to the service layer, and the parser carries on the lexical analysis and syntax analysis of the sql sentence.

2. The mysql parser uses MySQL syntax rules to validate and analyze queries.

For example, verify that the wrong keywords are used, or that the keywords are used in the correct order, or that quotation marks are correct.

Mysql identifies column names, table names, where, select/update/insert and other mysql keywords in the string, judges whether sql meets the grammar requirements according to grammar rules, and finally forms an abstract grammar tree (AST).

If the keyword has the misunderstanding to prompt the You have an error in your SQL syntax message, the specific error needs to pay attention to the content after the use near.

Mysql > elect * from iam_user where id = 0 mysql error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'elect * from iam_user where id = 0' at line 1 that's all for the article on "what mysql Analyzer is". Thank you for reading! I believe you all have a certain understanding of the knowledge of "what is a mysql analyzer". If you want to learn more, you are welcome to follow the industry information channel.

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.