Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ...
https://dev.mysql.com/doc/refman/8.4/en/show-status.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW STATUS accepts an optional GLOBAL or SESSION variable scope modifier: With a GLOBAL modifier, the ...
https://dev.mysql.com/doc/refman/8.4/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. The LIKE clause, if present, indicates which table names (not trigger names) to match and causes the statement to display triggers for those ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW VARIABLES accepts an optional GLOBAL or SESSION variable scope modifier: With a GLOBAL modifier, the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-statement-avg-latency-histogram.html
Displays a textual histogram graph of the average latency values across all normalized statements tracked within the Performance Schema events_statements_summary_by_digest table. This procedure can be used to display a very high-level picture of ...
https://dev.mysql.com/doc/refman/8.4/en/while.html
[begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the search_condition expression is true. statement_list consists of one or more SQL statements, each ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-statements-callable.html
Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 3.7 Connector/J: Using Connection.prepareCall() import java.sql.CallableStatement; ... For performance reasons, ...For more information on MySQL stored procedures, please refer to Using Stored ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using Connection.prepareCall() import java.sql.CallableStatement; ... For performance reasons, ...For more information on MySQL stored procedures, please refer to Using Stored ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This topic describes how to use the NL_SQL routine to generate and run SQL queries ...
https://dev.mysql.com/doc/refman/8.4/en/create-role.html
To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. (These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all ... CREATE ROLE [IF NOT EXISTS] role [, role ] ...