Search Results
https://dev.mysql.com/doc/refman/26.7/en/identifier-case-sensitivity.html
Object names may be considered duplicates if their uppercase forms are equal according to a binary collation. For more information, see Section 12.8.7, “Using Collation in INFORMATION_SCHEMA Searches”. In MySQL, databases correspond to ...
https://dev.mysql.com/doc/refman/26.7/en/import-table.html
Any collation IDs stored in the .sdi file must refer to the same collations on the export and import servers. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files.
https://dev.mysql.com/doc/refman/26.7/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Note A MERGE_THRESHOLD value ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/26.7/en/information-schema-routines-table.html
COLLATION_NAME For stored function character string return values, the collation name. COLLATION_CONNECTION The session value of the collation_connection system variable when the routine was created. DATABASE_COLLATION The collation of the database ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/26.7/en/information-schema-tables-table.html
The output does not explicitly list the table default character set, but the collation name begins with the character set name. The information_schema_stats_expiry system variable defines the period of time before cached table statistics expire. If ...
https://dev.mysql.com/doc/refman/26.7/en/json-search-functions.html
When no character set is specified for the return type, JSON_VALUE() uses utf8mb4 with the binary collation, which is case-sensitive; if utf8mb4 is specified as the character set for the result, the server uses the default collation for this ... The ...
https://dev.mysql.com/doc/refman/26.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/26.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the ...
https://dev.mysql.com/doc/refman/26.7/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/26.7/en/mysql-cluster-online-operations.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` int(11) DEFAULT NULL, `c3` int(11) DEFAULT NULL, PRIMARY KEY (`c1`) ) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 ... MySQL NDB ...