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/daemon-keyring-proxy-plugin.html
This is facilitated using the plugin named daemon_keyring_proxy_plugin that acts as a bridge between the plugin and component service APIs, and enables keyring plugins to continue to be used with no change to user-visible characteristics. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement that retrieves the rows to be traversed by the cursor. Cursor declarations must appear before handler declarations and after ...The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH ...
https://dev.mysql.com/doc/refman/8.0/en/declare.html
END compound statement and must be at its start, before any other statements. Variable and condition declarations must appear before cursor or handler declarations. The DECLARE statement is used to define various items local to a program: Local ...
https://dev.mysql.com/doc/refman/8.0/en/differences-from-ansi.html
We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between the MySQL and standard SQL privilege systems. For example, in ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. DROP FUNCTION also removes the function from the Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
ALGORITHM and LOCK clauses may be given to influence the table copying method and level of concurrency for reading and writing the table while its indexes are being modified. For more information, see Section 15.1.9, “ALTER TABLE Statement” ...
https://dev.mysql.com/doc/refman/8.0/en/drop-resource-group.html
The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If FORCE is not given and any threads are assigned to the group, an error occurs. Examples: Drop a group, failing if the group contains any ...
https://dev.mysql.com/doc/refman/8.0/en/drop-tablespace.html
mysql> DROP UNDO TABLESPACE undo_003; NDB Example This example shows how to drop an NDB tablespace myts having a data file named mydata-1.dat after first creating the tablespace, and assumes the existence of a log file group named mylg (see Section ... DROP [UNDO] TABLESPACE tablespace_name [ENGINE [=] engine_name] This statement drops a tablespace that was previously created using CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/dynamic-system-variables.html
Many server system variables are dynamic and can be set at runtime. Please see the corresponding item descriptions for details on setting and using the variables. For a description of the privilege requirements for setting system variables, see ...
https://dev.mysql.com/doc/refman/8.0/en/end-markers-in-json-system-variable.html
When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's key, if it has one, near the closing bracket. This variable affects both optimizer ...