PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html
For example, if e and é have the same sort value in a given collation, they compare as equal. For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. For binary strings (BINARY, VARBINARY, BLOB), ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
Some conditions apply to all spatial type casts, and some conditions apply only when the cast result is to have a particular spatial type. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
A special case occurs if you have old tables from before MySQL 4.1 where a nonbinary column contains values that actually are encoded in a character set different from the server's default character set. For example, an application might have stored ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/en/connection-options.html
Note These options have an effect only for connections that use a transport protocol subject to encryption; that is, TCP/IP and Unix socket-file connections. For example, these values do not have holes: --tls-version="TLSv1,TLSv1.1,TLSv1.2,TLSv1.3" ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server, whether connections are encrypted, and whether connections are ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0. CREATE ...
https://dev.mysql.com/doc/refman/8.0/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 ...