Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-metadata.html
getProceduresReturnsFunctions Pre-JDBC4 'DatabaseMetaData' API has only the 'getProcedures()' and 'getProcedureColumns()' methods, so they return metadata info for both stored procedures and functions. For JDBC4 and higher, default "true" value of ...JDBC4 was extended with the 'getFunctions()' and 'getFunctionColumns()' methods and the expected behaviours of previous methods are not well ...
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-3-0.html
(Bug #35929119) When a CallableStatement was used to call a stored procedure or function that did not exist on the server or that the client had no rights to access its parameters' metadata, Connector/J tried to infer the parameter metadata from the ... Version 8.3.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-troubleshooting-datadict.html
To address these messages, issue DROP TABLE statement to remove data about the missing table from the data dictionary. Restoring Orphan File-Per-Table ibd Files This procedure describes how to restore orphan file-per-table .ibd files to another ...