Search Results
https://dev.mysql.com/doc/refman/8.4/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. The number of columns retrieved by the SELECT statement must match the number of output ...If a ...
https://dev.mysql.com/doc/refman/8.4/en/return.html
RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a stored function. This statement is not used in stored procedures, ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see Section 15.7.7.9, “SHOW CREATE FUNCTION Statement”). To use either statement, you ...It returns the exact string that can be used to re-create the named stored ...
https://dev.mysql.com/doc/refman/8.4/en/show-profiles.html
SHOW PROFILES The SHOW PROFILES statement, together with SHOW PROFILE, displays profiling information that indicates resource usage for statements executed during the course of the current session. Note The SHOW PROFILE and SHOW PROFILES statements ...Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-component.html
Example: UNINSTALL COMPONENT 'file://component1', 'file://component2'; For information about component naming, see Section 15.7.4.3, “INSTALL COMPONENT Statement”. If any error occurs, the statement fails and has no effect. Note This statement ...A component provides services that are available to the server and other components; see Section 7.5, “MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.4/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...By ...
https://dev.mysql.com/doc/refman/8.4/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/8.4/en/binlog.html
To execute BINLOG statements when applying mysqlbinlog output, a user account requires the BINLOG_ADMIN privilege (or the deprecated SUPER privilege), or the REPLICATION_APPLIER privilege plus the appropriate privileges to execute each log event. It ...
https://dev.mysql.com/doc/refman/8.4/en/create-function.html
The CREATE FUNCTION statement is used to create stored functions and loadable functions: For information about creating stored functions, see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”. For information about creating ...