PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-server-side-help.html
To make a more specific request, please type 'help <item>', where <item> is one of the following topics: REPAIR TABLE REPEAT FUNCTION REPEAT LOOP REPLACE REPLACE FUNCTION . mysql> help search_string If you provide an argument to the help command, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
For example, thread/sql/one_connection corresponds to the thread function in the code responsible for handling a user connection, and thread/sql/main stands for the main() function of the server. This is the same value displayed in the ID column of ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL 8.0. This section describes how the query cache works when it is operational. Section 8.10.3.3, “Query Cache Configuration”, describes how to control whether it is ...
https://dev.mysql.com/doc/refman/5.7/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. There may be more than one if the function has multiple ...This statement is not used in stored procedures, triggers, or ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
For example, the C API provides a set of function calls that make up its prepared statement API. For example, you cannot use the mysql_stmt_prepare() C API function to prepare a PREPARE, EXECUTE, or DEALLOCATE PREPARE statement. SQL syntax for ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects-security.html
Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. The SQL SECURITY Characteristic For stored routines ...The ...
https://dev.mysql.com/doc/refman/5.7/en/stored-objects.html
Stored function: An object created with CREATE FUNCTION and used much like a built-in function. Terminology used in this document reflects the stored object hierarchy: Stored routines include stored procedures and functions. This chapter discusses ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
The following is an example of a function that takes a parameter, performs an operation using an SQL function, and returns the result. Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement ...