https://dev.mysql.com/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...
https://dev.mysql.com/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...
https://dev.mysql.com/user-resources.html
The value for each per-hour limit should be an integer representing a count per hour. For MAX_USER_CONNECTIONS, the limit is an integer representing the maximum number of simultaneous connections by the account. One means of restricting client use ...
https://dev.mysql.com/version-tokens-reference.html
Timeout values are nonnegative integers representing the time in seconds to wait to acquire locks before timing out with an error. The following discussion serves as a reference to these Version Tokens components: Version Tokens Functions Version ...
https://dev.mysql.com/view-updatability.html
Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table. Derived ...
https://dev.mysql.com/writing-information-schema-plugins.html
NAME is string-valued with a length of 10 and VALUE is integer-valued with a display width of 20. This section describes how to write a server-side INFORMATION_SCHEMA table plugin. For example code that implements such plugins, see the ...
https://dev.mysql.com/analyze-table.html
The value of N must be an integer in the range from 1 to 1024. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name DROP HISTOGRAM ON ...
https://dev.mysql.com/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. A leading 0b is case sensitive and cannot be written as 0B. To ensure numeric treatment of a bit literal, use it in numeric context. For example, a bit literal assigned to a ...
https://dev.mysql.com/c-api-prepared-statement-function-overview.html
The following list summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 28.6.10, “C API Prepared Statement Function Descriptions”. mysql_stmt_affected_rows(): Returns the ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
When converting an integer to string, ZEROFILL is honored with prepared statements in some cases where the MySQL server does not print the leading zeros. Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, ...
