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/ddl-rewriter-installation.html
Note If installed, the ddl_rewriter plugin involves some minimal overhead even when disabled. This section describes how to install or uninstall the ddl_rewriter plugin. For general information about installing plugins, see Section 7.6.1, ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
Note If you declare an alias for a table, you must use the alias when referring to the table: DELETE t1 FROM test AS t1, test2 WHERE ... DELETE is a DML statement that removes rows from a table. A DELETE statement can start with a WITH clause to ...
https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html
Note Prior to MySQL 8.0.22, if a derived table was materialized but not merged, MySQL materialized the entire table, then qualified all of the resulting rows with the WHERE condition. MySQL 8.0.22 and later supports derived condition pushdown for ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON. Examining a trace in the mysql command-line client can be made less difficult using the pager less ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
Note To upgrade the shared library associated with a loadable function, issue a DROP FUNCTION statement, upgrade the shared library, and then issue a CREATE FUNCTION statement. DROP FUNCTION [IF EXISTS] function_name This statement drops the ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
Notes A general InnoDB tablespace is not deleted automatically when the last table in the tablespace is dropped. DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using ...
https://dev.mysql.com/doc/refman/8.0/en/drop-trigger.html
A NOTE is generated for a nonexistent trigger when using IF EXISTS. DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires ...