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/replication-mode-change-online-enable-gtids.html
This procedure does not require taking the server offline and is suited to use in production. If it is possible to enable GTIDs on the replication source server, as described in this procedure, use this approach instead. The following procedure can ... This section describes how to enable GTID transactions, and optionally auto-positioning, on servers that are already online and using anonymous ...
https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html
SQL syntax for prepared statements can be used within stored procedures, but not in stored functions or triggers. To write C programs that use the CALL SQL statement to execute stored procedures that contain prepared statements, the ...Using ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
To update the tables to the expected structure, perform the MySQL upgrade procedure. The procs_priv table applies to stored routines (stored procedures and functions). A privilege granted at the routine level applies only to a single procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
The procedure used to populate the configuration directory with these files depends on the KMIP back end used with keyring_okv, as described elsewhere. The following procedure briefly summarizes the process of setting up keyring_okv for use with ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
Consequently, when the procedure sp1()is called, the newname variable returns the value 'bob' regardless of the value of the table1.xname column. Similarly, the cursor definition in the following procedure contains a SELECT statement that refers to ... The scope of a local variable is the BEGIN ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-objects-table.html
The value is one of 'EVENT' (Event Scheduler event), 'FUNCTION' (stored function), 'PROCEDURE' (stored procedure), 'TABLE' (base table), or 'TRIGGER' (trigger). The setup_objects table controls whether the Performance Schema monitors particular ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
The following procedure uses the increment procedure parameter and counter local variable: CREATE PROCEDURE p(increment INT) BEGIN DECLARE counter INT DEFAULT 0; WHILE counter < 10 DO -- ... An error occurs for attempts to apply them to user-defined ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The following example shows how to do this for the dorepeat() procedure just shown. The delimiter is changed to // to enable the entire definition to be passed to the ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-metadata.html
Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS statements to see routine characteristics. Use the SHOW PROCEDURE CODE and SHOW FUNCTION CODE ... To ...
https://dev.mysql.com/doc/refman/8.0/en/sys-sys-config.html
diagnostics.include_raw, @sys.diagnostics.include_raw If this option is ON, the diagnostics() procedure includes the raw output from querying the metrics view. statement_performance_analyzer.view, @sys.statement_performance_analyzer.view The custom ... This table contains sys schema configuration options, one row per ...