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/identifier-case-sensitivity.html
In MySQL, databases correspond to directories within the data directory. The following statement would not work because it refers to a table both as my_table and as MY_TABLE: mysql> SELECT * FROM my_table WHERE MY_TABLE.col=1; Partition, ...Each ...
https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, resource group and other object names are known as identifiers. Beginning with MySQL 8.0.32, use of the dollar sign as the ...Section 11.2.1, “Identifier Length Limits”, indicates the maximum length of each type of ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
Record locks for nonmatching rows are released after MySQL has evaluated the WHERE condition. For UPDATE statements, InnoDB does a “semi-consistent” read, such that it returns the latest committed version to MySQL so that MySQL can determine ...
https://dev.mysql.com/doc/refman/8.0/en/merge-storage-engine.html
When you create a MERGE table, MySQL creates a .MRG file on disk that contains the names of the underlying MyISAM tables that should be used as one. The table format of the MERGE table is stored in the MySQL data dictionary. Additional Resources A ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.0/en/range-optimization.html
MySQL tries to extract range conditions from the WHERE clause for each of the possible indexes. MySQL performs an additional check to filter out rows that satisfy the range condition but not the full WHERE clause. MySQL does not support merging ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover.html
Beginning with MySQL 8.0.22, you can use the asynchronous connection failover mechanism to automatically establish an asynchronous (source to replica) replication connection to a new source after the existing connection from a replica to its source ...The list of potential source servers is stored on the replica, and in the event of a connection failure, a new source is selected from the list based on a weighted priority that you ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features.html
The following sections provide information about what is supported and what is not in MySQL replication, and about specific issues and situations that may occur when replicating certain statements. If you use a feature on the source server that is ...Statement-based replication depends on compatibility at the SQL level between the source and ...
https://dev.mysql.com/doc/refman/8.0/en/select-into.html
Example: SELECT * FROM t1 FOR UPDATE INTO @myvar; The INTO position at the end of the statement is supported as of MySQL 8.0.20, and is the preferred position. The position before a locking clause is deprecated as of MySQL 8.0.20; expect support for ...INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci As of MySQL 8.0.16, MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-methods.html
There are two methods for installing MySQL from source: Use a standard MySQL source distribution. To obtain a standard distribution, see Section 2.1.3, “How to Get MySQL”. For instructions on building from a standard distribution, see Section ...Standard distributions are available as compressed tar files, Zip archives, or RPM ...