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/deploy-mysql-nonlinux-docker.html
Warning The MySQL Docker images provided by Oracle are built specifically for Linux platforms. Other platforms are not supported, and users running the MySQL Docker images from Oracle on them are doing so at their own risk. This section discusses ...
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In most cases, a DISTINCT clause ...
https://dev.mysql.com/doc/refman/8.0/en/do.html
DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
The most important differences between a document and the tables known from traditional relational databases are that the structure of a document does not have to be defined in advance, and a collection can contain multiple documents with different ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
Traditionally, relational databases such as MySQL have usually required a schema to be defined before documents can be stored. This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using ...
https://dev.mysql.com/doc/refman/8.0/en/drop-table.html
Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the statement removes the table definition, all its partitions, all data stored in those partitions, and all partition ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE TABLESPACE. The UNDO keyword, introduced in MySQL 8.0.14, must be specified to drop an undo tablespace. Only ...
https://dev.mysql.com/doc/refman/8.0/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Note In MySQL 5.7 and earlier, DROP VIEW returns an error if any views ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Certificates rely on asymmetric encryption algorithms that have two encryption keys (a public key and a secret key). With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
This is because rows referenced from ancestor operations in the join have not yet been retrieved when the scan filter is generated. This optimization improves the efficiency of direct comparisons between a nonindexed column and a constant. In such ...