Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-function.html
SHOW CREATE FUNCTION func_name This statement is similar to SHOW CREATE PROCEDURE but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/8.4/en/show-function-code.html
SHOW FUNCTION CODE func_name This statement is similar to SHOW PROCEDURE CODE but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/show-function-status.html
SHOW FUNCTION STATUS [LIKE 'pattern' | WHERE expr] This statement is similar to SHOW PROCEDURE STATUS but for stored functions.
https://dev.mysql.com/doc/refman/8.4/en/show-open-tables.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the ...
https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html
SHOW PARSE_TREE select_statement SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in JSON format. Note This statement is available only in debug builds, or if the MySQL server was built using ...It is ...
https://dev.mysql.com/doc/refman/8.4/en/show-plugins.html
SHOW PLUGINS output has these columns: Name The name used to refer to the plugin in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN.
https://dev.mysql.com/doc/refman/8.4/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.4/en/clone.html
CLONE clone_action clone_action: { LOCAL DATA DIRECTORY [=] 'clone_dir'; | INSTANCE FROM 'user'@'host':port IDENTIFIED BY 'password' [DATA DIRECTORY [=] 'clone_dir'] [REQUIRE [NO] SSL] } The CLONE statement is used to clone data locally or from a ...CLONE LOCAL DATA DIRECTORY syntax clones data from the local MySQL data directory to a directory on the same server or node where the MySQL server instance ...
https://dev.mysql.com/doc/refman/8.4/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...