Shulou(Shulou.com)06/01 Report--

Editor to share with you navicat set keyword capitalization method, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Sql statements can be formatted using navicat's formatting tool, which will help us standardize keywords and indent newlines, which greatly provides the readability of sql code. Here's how to use navicat format.

First of all, list the sql statement shown in the figure. If it is in this format, although it is not complicated, it must be awkward for everyone to read it.

Click the "format" menu in the menu bar of navicat, and first set [beautify SQL options].

In the beautify SQL option setting dialog box, you generally need to check the keyword capitalization, so that when beautifying the format, the SQL keyword will be converted to uppercase, and you can click the default button to restore to the default settings.

Now you can start to beautify the format of the above sql statement. Click the menu format, and then select beautify SQL.

After beautification, as shown in the figure, the chaotic SQL statements become much clearer, nesting and indentation help us deal with them, and keywords are all converted to uppercase.

The above is all the contents of this article entitled "how to capitalize keywords in navicat". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, 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.