https://dev.mysql.com/server-error-reference.html
Error number: 3056; Symbol: ER_CHANGE_MASTER_PASSWORD_LENGTH; SQLSTATE: HY000 Message: The password provided for the replication user exceeds the maximum length of 32 characters Error number: 3057; Symbol: ER_USER_LOCK_WRONG_NAME; SQLSTATE: 42000 ...
https://dev.mysql.com/show-columns.html
SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given table. SHOW COLUMNS displays information only for those columns for ...
https://dev.mysql.com/sql-mode.html
ANSI_QUOTES Treat " as an identifier quote character (like the ` quote character) and not as a string quote character. mysql> SET sql_mode = ''; mysql> SELECT NOT 1 BETWEEN -5 AND 5; -> 0 mysql> SET sql_mode = 'HIGH_NOT_PRECEDENCE'; mysql> SELECT ...
https://dev.mysql.com/storage-requirements.html
In the following table, M represents the declared column length in characters for nonbinary string types and bytes for binary string types. Data Type Storage Required CHAR(M) The compact family of InnoDB row formats optimize storage for ... InnoDB ...
https://dev.mysql.com/udf-arguments.html
If you want to receive a number, use the initialization function to specify that the argument should be coerced to a REAL_RESULT value: args->arg_type[2] = REAL_RESULT; char **args args->args communicates information to the initialization function ... The args parameter points to a UDF_ARGS structure that has the members listed here: unsigned int arg_count The number of ...
https://dev.mysql.com/with.html
The path column is widened to CHAR(200) to ensure that there is room for the longer path values produced by the recursive SELECT. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and ...
https://dev.mysql.com/c-api-plugin-functions.html
For example, a client that supports the use of authentication plugins normally causes a plugin to be loaded by calling mysql_options() to set the MYSQL_DEFAULT_AUTH and MYSQL_PLUGIN_DIR options: char *plugin_dir = "path_to_plugin_dir"; char ... This ...
https://dev.mysql.com/charset-compatibility.html
For MaxDB compatibility these two statements are the same: CREATE TABLE t1 (f1 CHAR(N) UNICODE); CREATE TABLE t1 (f1 CHAR(N) CHARACTER SET ucs2); .
https://dev.mysql.com/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/charset-unicode-utf8mb3.html
The utf8mb3 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Requires a maximum of three bytes per multibyte character. Applications that use UTF-8 data but require supplementary ...
