PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.01 sec) To change ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
As of MySQL 8.0.19, audit log functions convert string arguments to utf8mb4 and string return values are utf8mb4 strings. As of MySQL 8.0.19, the password is stored as a utf8mb4 string. Unless those objects are installed, the audit_log plugin ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. For example, applications that use one database might use the default of utf8mb4, whereas ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html
Since changing character sets can be a complex and time-consuming task, you should begin to prepare for this change now by using utf8mb4 for new applications. utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
row *************************** Table: auto_0 Create Table: CREATE TABLE `auto_0` ( `c1` varchar(50) DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.00 sec) mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `col1` int DEFAULT NULL, `col2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci If invisibility should be preserved, provide a definition ...An invisible column is normally hidden to queries, but can be accessed if explicitly ...
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html
search_str and path are always interpreted as utf8mb4 strings, regardless of their actual encoding. 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 ... The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-tips.html
The shortcut should set the console font to Lucida Console or some other compatible Unicode font, and pass the --default-character-set=utf8mb4 (or utf8mb3) option to mysql.exe. Alternatively, create a shortcut that only sets the console font, and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...