https://dev.mysql.com/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/mysql-nutshell.html
For example, given a table t with a TINYINT UNSIGNED column c, the optimizer can rewrite a condition such as WHERE c < 256 to WHERE 1 (and optimize the condition away altogether), or WHERE c >= 255 to WHERE c = 255. Such an index uses a key part ...
https://dev.mysql.com/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) This function creates a legal SQL string for use in an SQL statement. The mysql argument must be a valid, open connection ...
https://dev.mysql.com/performance-schema-optimization.html
Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their indexes. For example, include a WHERE clause that restricts retrieved rows based on ...
https://dev.mysql.com/glossary.html
The column itself must be of BIGINT UNSIGNED NOT NULL type, with a unique index named FTS_DOC_ID_INDEX. Prior to MySQL 5.6.3, the LSN was a 4-byte unsigned integer. The LSN became an 8-byte unsigned integer in MySQL 5.6.3 when the redo log file size ... These terms are commonly used in information about the MySQL database ...
https://dev.mysql.com/alter-table.html
To retain them, the statement must include them explicitly: ALTER TABLE t1 MODIFY col1 BIGINT UNSIGNED DEFAULT 1 COMMENT 'my column'; For data type changes using CHANGE or MODIFY, MySQL tries to convert existing column values to the new type as well ... ALTER TABLE tbl_name [alter_specification [, alter_specification] ...] [partition_options] alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX|KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/arithmetic-functions.html
If both operands are integers and any of them are unsigned, the result is an unsigned integer. For subtraction, if the NO_UNSIGNED_SUBTRACTION SQL mode is enabled, the result is signed even if any operand is unsigned. Table 12.11 Arithmetic ...
https://dev.mysql.com/mysql-stmt-execute.html
int mysql_stmt_execute(MYSQL_STMT *stmt) mysql_stmt_execute() executes the prepared query associated with the statement handler. The currently bound parameter marker values are sent to server during this call, and the server replaces the markers ...
https://dev.mysql.com/udf-arguments.html
The args parameter points to a UDF_ARGS structure that has the members listed here: unsigned int arg_count The number of arguments. unsigned long *lengths For the initialization function, the lengths array indicates the maximum string length for ...
https://dev.mysql.com/udf-calling.html
unsigned int decimals The number of decimal digits to the right of the decimal point. This section describes the different functions that you need to define when you create a simple UDF. Section 29.4.2, “Adding a New User-Defined Function”, ...
