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/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d container-registry.oracle.com/mysql/community-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts the MySQL Server with utf8mb4 as the default character set and ...A ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ucs2 character set. The remarks for utf8mb3 also apply to utf8mb4, and the remarks for ucs2 also apply to utf16, utf16le, and utf32. Full-text searches ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
mysql> SELECT COERCIBILITY('abc' COLLATE utf8mb4_swedish_ci); -> 0 mysql> SELECT COERCIBILITY(USER()); -> 3 mysql> SELECT COERCIBILITY('abc'); -> 4 mysql> SELECT COERCIBILITY(1000); -> 5 The return values have the meanings shown in the following ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL, `c` int(11) GENERATED ALWAYS AS (5) VIRTUAL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; However, metadata for such a column does appear in the ... The ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/locale-support.html
The locale indicated by the lc_time_names system variable controls the language used to display day and month names and abbreviations. This variable affects the output from the DATE_FORMAT(), DAYNAME(), and MONTHNAME() functions. The lc_time_names ...
https://dev.mysql.com/doc/refman/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
The default character set has changed from latin1 to utf8mb4 in MySQL 8.0. After the upgrade is completed, the default character set can be changed to utf8mb4. When you upgrade servers that participate in a replication topology, you need to take ...