| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 0 | 0 |
HELP_DATE |
1 |
This help information was generated from the MySQL... |
|
|
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 1 | 1 |
HELP_VERSION |
1 |
This help information was generated from the MySQL... |
|
|
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 2 | 2 |
AUTO_INCREMENT |
2 |
The AUTO_INCREMENT attribute can be used to genera... |
CREATE TABLE animals (
id MEDIUMINT NOT NULL ...
|
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 3 | 3 |
HELP COMMAND |
3 |
Syntax:
mysql> help search_string
If you provide ... |
|
https://dev.mysql.com/doc/refman/8.0/en/mysql-server-side-help.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 4 | 4 |
TRUE |
4 |
The constants TRUE and FALSE evaluate to 1 and 0, ... |
|
https://dev.mysql.com/doc/refman/8.0/en/boolean-literals.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 5 | 5 |
FALSE |
4 |
The constants TRUE and FALSE evaluate to 1 and 0, ... |
|
https://dev.mysql.com/doc/refman/8.0/en/boolean-literals.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 6 | 6 |
BIT |
2 |
BIT[(M)]
A bit-value type. M indicates the number... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 7 | 7 |
TINYINT |
2 |
TINYINT[(M)] [UNSIGNED] [ZEROFILL]
A very small i... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 8 | 8 |
BOOLEAN |
2 |
BOOL, BOOLEAN
These types are synonyms for TINYIN... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 9 | 9 |
SMALLINT |
2 |
SMALLINT[(M)] [UNSIGNED] [ZEROFILL]
A small integ... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 10 | 10 |
MEDIUMINT |
2 |
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-siz... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 11 | 11 |
INT |
2 |
INT[(M)] [UNSIGNED] [ZEROFILL]
A normal-size inte... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 12 | 12 |
INTEGER |
2 |
INTEGER[(M)] [UNSIGNED] [ZEROFILL]
This type is a... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 13 | 13 |
BIGINT |
2 |
BIGINT[(M)] [UNSIGNED] [ZEROFILL]
A large integer... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 14 | 14 |
DECIMAL |
2 |
DECIMAL[(M[,D])] [UNSIGNED] [ZEROFILL]
A packed "... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 15 | 15 |
DEC |
2 |
DEC[(M[,D])] [UNSIGNED] [ZEROFILL], NUMERIC[(M[,D]... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 16 | 16 |
FLOAT |
2 |
FLOAT[(M,D)] [UNSIGNED] [ZEROFILL]
A small (singl... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 17 | 17 |
DOUBLE |
2 |
DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
A normal-size... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 18 | 18 |
DOUBLE PRECISION |
2 |
DOUBLE PRECISION[(M,D)] [UNSIGNED] [ZEROFILL], REA... |
|
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 19 | 19 |
DATE |
2 |
DATE
A date. The supported range is '1000-01-01' ... |
|
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 20 | 20 |
DATETIME |
2 |
DATETIME[(fsp)]
A date and time combination. The ... |
|
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 21 | 21 |
TIMESTAMP |
2 |
TIMESTAMP[(fsp)]
A timestamp. The range is '1970-... |
|
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 22 | 22 |
TIME |
2 |
TIME[(fsp)]
A time. The range is '-838:59:59.0000... |
|
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 23 | 23 |
YEAR DATA TYPE |
2 |
YEAR[(4)]
A year in 4-digit format. MySQL display... |
|
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-overview.html |
| | Edit | Copy | DeleteDELETE FROM `help_topic` WHERE `help_topic`.`help_topic_id` = 24 | 24 |
CHAR |
2 |
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] ... |
|
https://dev.mysql.com/doc/refman/8.0/en/string-type-overview.html |