https://dev.mysql.com/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. Exact-value numeric literals have an integer part or fractional part, or both. An integer may be used in a floating-point context; ...Numbers may be preceded by - or + to indicate a negative or positive value, ...
https://dev.mysql.com/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. This can simply be the name of a column whose type is one ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/plugin-data-structures.html
MYSQL_THDVAR_STR(name, opt, comment, check, update, default) MYSQL_SYSVAR_STR(name, varname, opt, comment, check, update, default) Integer system variables, of which there are several varieties. version: The plugin version as an array of three ... A ...
https://dev.mysql.com/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. The expression is exact and is evaluated using integer arithmetic and has a ...
https://dev.mysql.com/string-functions.html
For functions that take length arguments, noninteger arguments are rounded to the nearest integer. [USING charset_name]) CHAR() interprets each argument N as an integer and returns a string consisting of the characters given by the code values of ...
https://dev.mysql.com/c-api-prepared-statement-type-conversions.html
Here are some examples: If you use MYSQL_TYPE_LONG with an int variable to pass an integer value to the server that is to be stored into a FLOAT column, MySQL converts the value to floating-point format before storing it. Prepared statements ...
https://dev.mysql.com/diagnostics-area.html
The statement information part of the diagnostics area contains these items: NUMBER: An integer indicating the number of condition areas that have information. ROW_COUNT: An integer indicating the number of rows affected by the statement. SQL ...
https://dev.mysql.com/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you will need. See Section 11.2.1, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT” for ...
https://dev.mysql.com/innodb-auto-increment-handling.html
If the AUTO_INCREMENT value becomes larger than the maximum integer for the specified integer type In all lock modes (0, 1, and 2), the behavior of the auto-increment mechanism is not defined if the value becomes larger than the maximum integer that ... InnoDB provides a configurable locking mechanism that can significantly improve scalability and performance of SQL statements that add rows to tables with AUTO_INCREMENT ...
https://dev.mysql.com/innodb-memcached-internals.html
Because the InnoDB memcached plugin is tightly integrated with a single memcached daemon, and the in-memory caching mechanism is handled by MySQL and the InnoDB buffer pool, this column is rarely needed. Because the InnoDB memcached plugin is ...
