PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
ALTER ROUTINE Enables use of statements that alter or drop stored routines (stored procedures and functions). CREATE ROUTINE Enables use of statements that create stored routines (stored procedures and functions). EXECUTE Enables use of statements ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL also can make some procedures shorter if a given handler can handle part of a situation, then pass the condition “up the line” to another handler. RESIGNAL Alone A simple RESIGNAL alone means “pass on the error with no change.” It ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
The auto-rejoin attempts and the time between them are called the auto-rejoin procedure. If you do want to intervene to take the member offline during the auto-rejoin procedure, the member can be stopped manually at any time by using a STOP ... The ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
Historically, used by some Connector/J, Connector/ODBC, and Connector/PHP developers to work around issues with server-side stored procedures. stored program A stored routine (procedure or function), trigger, or Event Scheduler event. An API ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
--exclude-routines=routine_list Command-Line Format --exclude-routines=routine_list Type String Do not dump the events in routine_list, which is a list of one or more comma-separated routine (stored procedure or function) names. mysqlpump supports ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
The object_type clause, if present, should be specified as TABLE, FUNCTION, or PROCEDURE when the following object is a table, a stored function, or a stored procedure. Stored Routine Privileges The ALTER ROUTINE, CREATE ROUTINE, EXECUTE, and GRANT ...Never alter the structure of tables in the mysql system schema in any manner except by means of the procedure described in Chapter 3, Upgrading ...
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 ...If you create ...Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is ...
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/grant-tables.html
The procs_priv table applies to stored routines (stored procedures and functions). To update the tables to the expected structure, perform the MySQL upgrade procedure. The procs_priv scope columns indicate the stored routine to which each row ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
An error occurs for attempts to apply them to user-defined variables, stored procedure or function parameters, or stored program local variables. An error occurs for attempts to assign DEFAULT to user-defined variables, stored procedure or function ...Parameter and Local Variable Assignment SET applies to parameters and local variables in the context of the stored object within which they are ...variable: { user_var_name | param_name | local_var_name | ...