https://dev.mysql.com/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/gis-data-formats.html
WKB uses 1-byte unsigned integers, 4-byte unsigned integers, and 8-byte double-precision numbers (IEEE 754 format). Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary ...
https://dev.mysql.com/global-error-reference.html
Error number: 79; Symbol: EE_INCORRECT_UINT_VALUE_FOR_OPTION; Message: Incorrect unsigned integer value: '%s'. Error number: 81; Symbol: EE_ADJUSTED_UNSIGNED_VALUE_FOR_OPTION; Message: option '%s': unsigned value %s adjusted to %s. This section ...
https://dev.mysql.com/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/information-functions.html
LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...
https://dev.mysql.com/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/integer-types.html
MySQL supports the SQL standard integer types INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. The following table shows the required storage and range for each ...
https://dev.mysql.com/load-data.html
INTO Syntax”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of the FIELDS and LINES clauses is the same for both statements. You can also load data files by using the ...
https://dev.mysql.com/mathematical-functions.html
mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT COT(0); -> out-of-range error CRC32(expr) Computes a cyclic redundancy check value and returns a 32-bit unsigned value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); -> 32 This function ...
https://dev.mysql.com/miscellaneous-functions.html
Note To store values generated by INET_ATON(), use an INT UNSIGNED column rather than INT, which is signed. UUID_SHORT() Returns a “short” universal identifier as a 64-bit unsigned integer. The function return value and type are the same as the ...
