MySQL learning notes help document

MySQL learning notes help document

View system help

help contents

mysql> help contents;
You asked for help about 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
  Language Structure
  Plugins
  Procedures
  Storage Engines
  Table Maintenance
  Transactions
  User-Defined Functions
  Utility

Table of contents for help documentation

View data types

help data types

mysql> help data types;
You asked for help about 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
  DOUBLE
  DOUBLE PRECISION
  ENUM
  FLOAT
  INT
  INTEGER
  LONGBLOB
  LONGTEXT
  MEDIUMBLOB
  MEDIUMINT
  MEDIUMTEXT
  SET DATA TYPE
  SMALLINT
  TEXT
  TIME
  TIMESTAMP
  TINYBLOB
  TINYINT
  TINYTEXT
  VARBINARY
  VARCHAR
  YEAR DATA TYPE

View Integers

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.
URL: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html
mysql> help tinyint;
Name: 'TINYINT'
Description:
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small integer. The signed range is -128 to 127. The unsigned
range is 0 to 255.
URL: http://dev.mysql.com/doc/refman/5.7/en/numeric-type-overview.html

You may also be interested in:
  • Detailed explanation of transaction isolation levels in MySql study notes
  • MySQL learning notes: data engine
  • Basic knowledge of MySQL learning notes
  • MySQL learning notes: how to add, delete and modify data
  • MySQL learning notes: how to create, delete, and modify tables
  • Summary of MySQL learning notes
  • A summary of MySQL study notes of 1,000 lines
  • MySQL Learning Notes 5: Modify Table (alter table)
  • MySQL Learning Notes 4: Integrity Constraint Restriction Fields
  • MySQL Learning Notes 1: Installation and Login (Multiple Methods)
  • Complete MySQL Learning Notes

<<:  How to install Nginx and configure multiple domain names

>>:  JavaScript clicks the button to generate a 4-digit random verification code

Recommend

The difference and usage of Ctrl+z, Ctrl+c and Ctrl+d in Linux commands

What does Ctrl+c, Ctrl+d, Ctrl+z mean in Linux? C...

CSS implements the bottom tapbar function

Now many mobile phones have the function of switc...

HTML multi-header table code

1. Multi-header table code Copy code The code is a...

Example of how to create and run multiple MySQL containers in Docker

1. Use the mysql/mysql-server:latest image to qui...

Steps to modify the MySQL database data file path under Linux

After installing the MySQL database using the rpm...

Specific use of the wx.getUserProfile interface in the applet

Recently, WeChat Mini Program has proposed adjust...

Share the responsive frameworks commonly used by web design masters (summary)

This article introduces and shares the responsive...

Implementing CommonJS modularity in browsers without compilation/server

Table of contents introduction 1. What is one-cli...

Whitespace processing in HTML/CSS and how to preserve whitespace in the page

Whitespace rules in HTML In HTML, multiple spaces...

MySQL learning tutorial clustered index

Clustering is actually relative to the InnoDB dat...

The difference between Display, Visibility, Opacity, rgba and z-index: -1 in CSS

We often need to control the hidden, transparent ...

Detailed explanation of the use of custom parameters in MySQL

MySQL variables include system variables and syst...

Front-end development must learn to understand HTML tags every day (1)

2.1 Semanticization makes your web pages better u...

React implements infinite loop scrolling information

This article shares the specific code of react to...

Write a mysql data backup script using shell

Ideas It's actually very simple Write a shell...