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/innodb-online-ddl-operations.html
The CREATE INDEX statement only finishes after all transactions that are accessing the table are completed, so that the initial state of the index reflects the most recent contents of the table. Online DDL support for adding secondary indexes means ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Previously, these tables were created in individual tablespace files in the mysql database directory. The change of grant-table storage engine underlies an accompanying change in MySQL 8.0 to the behavior of account-management statements such as ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/charset-literal.html
Example 1: mysql> SET NAMES latin1; mysql> SELECT HEX('à\n'), HEX(_sjis'à\n'); +------------+-----------------+ | HEX('à\n') | HEX(_sjis'à\n') | +------------+-----------------+ | E00A | E00A | +------------+-----------------+ Here, à ... Every ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode.html
The UTF-8 (Unicode Transformation Format with 8-bit units) method for encoding Unicode data is implemented according to RFC 3629, which describes encoding sequences that take from one to four bytes. The idea of UTF-8 is that various Unicode ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-commands.html
The special character sequences that can be used in the prompt are described later in this section. The string for defining the prompt can contain the following special sequences. There is some overlap in the set of permissible prompt options and ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
mysql> SELECT REGEXP_LIKE('fofo', '^f.*$'); -> 1 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '^f.*$'); -> 0 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '^f.*$', 'm'); -> 1 mysql> SELECT REGEXP_LIKE('fo\r\nfo', '(?m)^f.*$'); -> 1 a* Match any sequence of zero or ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgmd.html
The files are named sequentially in order of creation using the following format: ndb_node-id_config.bin.seq-number node-id is the management server's node ID; seq-number is a sequence number, beginning with 1. Otherwise—that is, if you wish to ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Can I run NDB Cluster nodes inside virtual machines (such as those created by VMWare, VirtualBox, Parallels, or Xen)? A.10.13. You must also remember to account for any column indexes as follows: Each primary key or hash index created for an ... In ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
This occurs even when the function name is used in nonexpression context: mysql> CREATE TABLE count(i INT); ERROR 1064 (42000): You have an error in your SQL syntax ... To minimize the dependency of SQL code on the IGNORE_SPACE setting, use these ...