How to use commands in Mysql to achieve hierarchical search help detailed explanation

Preface

This article mainly introduces the relevant content of using MySQL command hierarchical search help. The sample in this article is based on the branch version of msql MariaDB-10.1.19, which is shared for your reference and learning. Let's take a look at the detailed introduction together.

Search all help

If we want to know what help mysql can provide us, we can use the following command

? contents

Or you can replace ? with help, the two have the same effect.

help contents

The effect is as follows

? is equivalent to help. For simplicity, we will use ? below, but readers need to know that if we use help, the effect is the same.

Various explanations

Rating View Help

Now that we know what types of help we can find, we can use question mark + space + specific name to search for different items == case insensitive ==

For example, I want to find out which data types are supported

? data type

The effect is as shown

There are many data types. Usually we may only use char, varchar, int, boolean, bit, timestamp, datetime, float, etc., but there are many data types that we don't know and rarely use, such as BIGINT, ENUM, BLOB, etc. So when we need to understand the characteristics of a certain type more deeply or want to know if there is a more suitable data type, such as when optimizing the database, we can use ? to find the corresponding data type.

As shown below

Now, we know that BLOB is a data type that can hold 65535 bytes.

Based on this method, you can save time on Baidu in actual development and directly find the required help step by step

Summarize

The above is the full content of this article. I hope that the content of this article can bring some help to your study or work. If you have any questions, you can leave a message to communicate. Thank you for your support of 123WORDPRESS.COM.