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

This article shows you how to view MySQL official documents, which are concise and easy to understand. I hope you can gain something through the detailed introduction of this article.

1. First acquaintance with official documents

First of all, open the home page of the reference document. Here, take version 5.7 as an example, home address: https://dev.mysql.com/doc/refman/5.7/en/

On the left side of the home page is the catalog, and there is a search box at the top of the directory. You can switch to the version in the upper right corner of the home page. For example, if you want to see version 8.0, you can switch to the corresponding version. Next, we know the contents of the catalogue. From the side catalog bar, we can see that the reference manual is divided into different chapters according to classification. It is suggested that you first read the first chapter General Information.

It can be seen that the first chapter introduces the content related to this version of MySQL as a whole, and reading the first chapter will help us to make better use of this document. The more important sections in the following directory are installation and upgrade, MySQL service management, backup and recovery, optimization, field types, SQL statements, InnoDB storage engine, master-slave replication, and so on. At this point, we have a general understanding of the MySQL official documentation, so let's take a look at how to use it.

two。 Read live documents

In general, when we encounter problems or have knowledge we want to know, we go to the official documents. At this time, we are reading with a goal, in which case we should make a quick decision. If you are familiar with the document directory, then you can quickly find the relevant content, if you are not familiar with the document, you should make good use of search, such as if you want to know how to create an index, type index in the search box, and then you can search out the relevant sections of the index.

Some students may have said that this document is all in English and I can't quite understand it. In fact, I would like to say that most of the English in the reference documents is easy to understand. If you read through it, you can probably know what it means. If you don't understand it, you can translate it with Google Translation or other plug-ins. It is recommended that you open two identical tabs, one in English and the other in Chinese with the help of a browser, so that you can read it on both sides.

We should read "live" documents, read them flexibly, and recommend reading and testing at the same time. At the same time, it is also necessary to read the comprehensive, some parameter variables may behave differently in different versions. It is not recommended to read the document aimlessly, it is recommended to read it in a planned way, for example, if you want to learn about the InnoDB engine, then you can read the chapter on the InnoDB storage engine on your own schedule.

3. A few tips

In addition to the above good use of search box search techniques, here are a few more tips. I don't know if you have ever encountered such a situation, that is, you have used a certain grammar before, but this time you can't remember it. At this point, you can search or browse the official documents online, but it is easier to use the help documentation that comes with the command line. For example, if you want to know the create database parameter, enter it directly on the MySQL command line? Create database is OK, the command line will automatically output the relevant content and give a link to the document, is not a lot of convenience.

Mysql >? Create database Name: 'CREATE DATABASE'Description:Syntax:CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_specification]... create_specification: [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_nameCREATE DATABASE creates a database with the given name. To use thisstatement, you need the CREATE privilege for the database. CREATESCHEMA is a synonym for CREATE DATABASE.URL: http://dev.mysql.com/doc/refman/5.7/en/create-database.html

There are many examples of statements in MySQL documents, and there are also some specifications. For example, take the above create database statement as an example, the contents in brackets [] can be omitted, the contents in curly braces {} are optional, and different options are separated by vertical bars. Understanding these will help us to quickly understand the usage of related sentences.

In fact, in addition to MySQL official documents, MySQL official also provides a variety of other network resources, the following is a brief introduction:

Community Edition download site: https://dev.mysql.com/downloads/ release Notes Manual There are various versions of the new content: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/https://dev.mysql.com/doc/relnotes/mysql/8.0/en/ View and submit bug website: https://bugs.mysql.com/MySQL team blog: https://mysqlserverteam.com/ the above content is how to view MySQL official documents, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, 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.