The use of MySQL's help

The use of help in MySQL mainly has the following two aspects:

1 Find Help by hierarchy:? | Help + category name

Mysql>?                Contents #有哪些分类

You asked-Help on Help category: "Contents"

For more information, type ' help <item> ', where <item> is one of the following

Categories

Account Management

Administration

Compound statements

Data Definition

Data manipulation

Data Types

Functions

Functions and Modifiers for use with GROUP by

Geographic Features

Help Metadata

Mysql>? Data Types #查看数据有哪些类型

You asked-Help on Help category: "Data Types"

For more information, type ' help <item> ', where <item> is one of the following

Topics

Auto_increment

BIGINT

BINARY

BIT

Blob

BLOB DATA TYPE

BOOLEAN

CHAR

CHAR BYTE

DATE

Datetime

DEC

DECIMAL

mysql> help int; #关于数据类型的说明

Name: ' INT '

Description:

int[(M)] [UNSIGNED] [Zerofill]

A normal-size Integer. The signed range is-2147483648 to 2147483647.

The unsigned range is 0 to 4294967295.

2 Quick Check Help

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_name

CREATE database creates a database with the given name. To use this

statement, you need the CREATE privilege for the database. CREATE

SCHEMA is a synonym for CREATE DATABASE.

......

mysql> help CREATE table;

Name: ' CREATE TABLE '

Description:

Syntax:

CREATE [temporary] TABLE [IF not EXISTS] Tbl_name

(Create_definition,...)

[Table_options]

[Partition_options]

CREATE [temporary] TABLE [IF not EXISTS] Tbl_name

[(Create_definition,...)]

[Table_options]

[Partition_options]

Select_statement

CREATE [temporary] TABLE [IF not EXISTS] Tbl_name

{Like Old_tbl_name | (Like Old_tbl_name)}

......

This article from "10,000 years too long, seize" blog, please be sure to keep this source http://zengwj1949.blog.51cto.com/10747365/1920336

The use of MySQL's help