Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
BMP characters have these characteristics: Their code point values are between 0 and 65535 (or U+0000 and U+FFFF). Unicode support for supplementary characters requires character sets that have a range outside BMP characters and therefore take more ... The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
In this case, the cloning operation does not have to wait for a backup lock on the donor. If your cloning operation is not achieving the desired data transfer rate and you have available bandwidth, check I/O usage on the recipient and donor. This ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
Consequently, the following two commands have two completely different meanings: mysql -ptest mysql -p test The first command instructs mysql to use a password value of test, but specifies no default database. Program options specified on the ...
https://dev.mysql.com/doc/refman/8.4/en/correlated-subqueries.html
To be eligible, a WHERE clause predicate must have one operand that contains only inner references and one operand that contains only outer references. A correlated subquery is a subquery that contains a reference to a table that also appears in ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
For example, you cannot have a tablespace and a log file group with the same name, or a tablespace and a data file with the same name. REDO_BUFFER_SIZE, NODEGROUP, WAIT, and COMMENT are parsed but ignored, and so have no effect in MySQL 8.4. CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN comments do not support TINYBLOB or TINYTEXT columns, since these have an inline part (only) of fixed size, and no separate parts to store elsewhere. It is also possible to use the ndb_table_no_logging system variable to cause any NDB ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
This means that any NDB table having one or more JSON columns must have a primary key, else it cannot be recorded in the binary log. A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
With REPLACE, new rows replace rows that have the same unique key value. If you want to have indexes in the created table, you should specify these before the SELECT statement: mysql> CREATE TABLE bar (UNIQUE (n)) SELECT n FROM foo; For CREATE TABLE ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...