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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or function). (DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for ...(If ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
It returns characteristics of a stored procedure, such as the database, name, type, creator, creation and modification dates, and character set information. SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. A ...To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that includes the ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html
It displays a representation of the internal implementation of the named stored procedure. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. A similar ...To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege at the global ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
It returns the exact string that can be used to re-create the named stored procedure. SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see ...To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that includes the ...
https://dev.mysql.com/doc/refman/8.0/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. Traditionally, relational databases such as MySQL have usually required a schema to be defined before documents can be ...If your intention is to use MySQL in a traditional (SQL) way, this chapter is probably not relevant to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-mysql-security-procedures.html
In this section, we discuss MySQL standard security procedures as they apply to running NDB Cluster. In general, any standard procedure for running MySQL securely also applies to running a MySQL Server as part of an NDB Cluster. First and foremost, ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller. It is not permitted to assign the ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The delimiter is changed to // to enable the entire definition to be passed to the server as a single statement, and then restored to ; before invoking the procedure. This ...
https://dev.mysql.com/doc/refman/8.0/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. The quick-start guides (tutorials) in this chapter help you to get ...You can use MySQL Shell to prototype applications, execute queries and update ...