PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
These include DML and DDL operations on tables, views, stored procedures, and stored functions, as well as LOCK TABLES, FLUSH TABLES WITH READ LOCK, and HANDLER statements. For details, see Section 10.2.1.16, “ORDER BY Optimization” ...Note Some ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/8.0/en/document-store-concepts.html
This section explains the concepts introduced as part of using MySQL as a document store. JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for ...
https://dev.mysql.com/doc/refman/8.0/en/stored-routines-metadata.html
To obtain metadata about stored routines: Query the ROUTINES table of the INFORMATION_SCHEMA database. Use the SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION statements to see routine definitions. Use the SHOW PROCEDURE STATUS and SHOW FUNCTION ...
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/replication-gtids-functions.html
The procedure used is to back up server2 using mysqldump, then to restore this backup on server1. This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided ...GTID_SUBTRACT(): Returns the GTIDs from one GTID set that are not in ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statement-performance-analyzer.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables.
https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html
(The sum of the number of prepared statements across all sessions.) Stored programs (stored procedures and functions, triggers, and events). The stored_program_cache system variable indicates the approximate number of stored programs the server ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
If a setting other than current is chosen, the current settings are restored at the end of the procedure. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a ...