PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-types.html
The TIMESTAMP and DATETIME types have special automatic updating behavior, described in Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. The date and time data types for representing temporal values are DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data directory. MySQL ...
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 ...