PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
This includes replication of CREATE statements for stored programs (stored procedures and functions, triggers, and events) that are executed while the current sql_mode value includes any of the removed modes. In previous MySQL series, dictionary ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. ORDINAL_POSITION For successive parameters of a stored procedure or function, the ...For a stored function, there is also a row that applies to the function return value (as described by the RETURNS ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects. The effect of a stored routine or trigger upon the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. For stored program objects, the Performance Schema takes the ENABLED and TIMED columns directly from the setup_objects row. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
It may be possible in some cases to revert a recent upgrade from one NDB 8.0 minor release version to a later one, and to restore the needed states of any MySQL Server instances running as SQL nodes. The procedure outlined next provides the basic ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory-initialization.html
Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data Directory Initialization Post-Initialization root Password Assignment Data Directory Initialization Overview In the examples shown here, the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-hashicorp-plugin.html
The setup procedure also results in a store path of /v1/kv/mysql, which is the value to assign to keyring_hashicorp_commit_store_path. No key information is permanently stored in MySQL server local storage. (An optional in-memory key cache may be ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
--routines, -R Command-Line Format --routines Include stored routines (procedures and functions) for the dumped databases in the output. These may be used when dumping stored programs to preserve their character encodings. For large-scale backup and ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
To store and reuse SSL session data, use this procedure: Invoke mysql to establish an encrypted connection to a server running MySQL 8.0.29 or higher. To reconfigure the SSL session cache at runtime, use this procedure: Set each cache-related system ... As of MySQL 8.0.29, MySQL client programs may elect to resume a prior SSL session, provided that the server has the session in its runtime ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
There are limitations on what can appear in statements that a trigger executes when activated: The trigger cannot use the CALL statement to invoke stored procedures that return data to the client or that use dynamic SQL. (Stored procedures are ...