Search Results
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/import-table.html
The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files. IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not include built-in (native) functions or loadable functions. The ROUTINES table has these columns: SPECIFIC_NAME The ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
This section describes limits for InnoDB tables, indexes, tablespaces, and other aspects of the InnoDB storage engine. The index key prefix length limit is 3072 bytes for InnoDB tables that use DYNAMIC or COMPRESSED row format. The index key prefix ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
For best efficiency, specify a combination of innodb_buffer_pool_instances and innodb_buffer_pool_size so that each buffer pool instance is at least 1GB. For information on the combination of settings on a replica that is most resilient to ...
https://dev.mysql.com/doc/refman/8.4/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. As a result, the address value for rows within each name group is ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...