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/create-table-select.html
For more information, see Section 15.1.1, “Atomic Data Definition Statement Support”. For more information, see The Effect of IGNORE on Statement Execution. Such statements produce a warning in the error log when using statement-based mode and ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/8.0/en/create-temporary-table.html
When innodb_strict_mode is enabled (the default), CREATE TEMPORARY TABLE returns an error if ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE is specified. If innodb_strict_mode is disabled, warnings are issued and the temporary table is created using a ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
Consult the more detailed descriptions for additional information about particular data types, such as the permissible formats in which you can specify values. MySQL supports SQL data types in several categories: numeric types, date and time types, ...
https://dev.mysql.com/doc/refman/8.0/en/database-use.html
Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You can do so by creating tables to hold your data and loading them with the desired information. It is ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
However, there may be some alteration of the value or loss of information. For example, although DATE, DATETIME, and TIMESTAMP values all can be specified using the same set of formats, the types do not all have the same range of values. Conversion ... To some extent, you can convert a value from one temporal type to ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-options.html
To control activation of the ddl_rewriter plugin, use this option: --ddl-rewriter[=value] Command-Line Format --ddl-rewriter[=value] Introduced 8.0.16 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls ... This section describes the command options that control operation of the ddl_rewriter ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the ...
https://dev.mysql.com/doc/refman/8.0/en/derived-table-optimization.html
The same idea applies to EXPLAIN output in TRADITIONAL format: Subqueries for other references are not shown. The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
Each role name uses the format described in Section 8.2.5, “Specifying Role Names”. DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global DROP ROLE or CREATE USER privilege. When ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not written to the binary log, regardless of the logging format that is in use. DROP SERVER [ IF EXISTS ...