MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 21 to 30 of 32 total results

https://dev.mysql.com/doc/refman/5.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...

9.2.3 Identifier Case Sensitivity

https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html

That is true for names of cursors, conditions, procedures, functions, savepoints, stored routine parameters, stored program local variables, and plugins. In MySQL, databases correspond to directories within the data directory. Each table within a ...

25.6 Performance Schema Instrument Naming Conventions

https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html

For example, the statement/sp/cfetch and statement/sp/freturn instruments are used cursor fetch and function return instructions. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...

5.1.9 Server Status Variables

https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html

Com_stmt_fetch stands for the total number of network round-trips issued when fetching from cursors. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by ...

13.6.7.7 The MySQL Diagnostics Area

https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html

SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...

13.6 Compound Statements

https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html

A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and cursors; and flow control constructs such as loops and conditional tests. END compound statement and other statements that can be used ...

13.6.4.1 Local Variable DECLARE Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-local-variable.html

type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an expression; it need not be a constant. If the DEFAULT clause ...

8.10.4 Caching of Prepared Statements and Stored Programs

https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html

These might be used in statements specific to stored programs, such as DECLARE CURSOR or flow-control statements such as IF, CASE, and RETURN. For certain statements that a client might execute multiple times during a session, the server converts ...

13.6.7.1 DECLARE ... CONDITION Statement

https://dev.mysql.com/doc/refman/5.7/en/declare-condition.html

DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...

5.8.4.1 mysqld DTrace Probe Reference

https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html

1 Executed prepared statement 2 Executed cursor statement 3 Executed query in stored procedure query-exec-done: Triggered when the execution of the query has completed. MySQL supports the following static probes, organized into groups of ...

Displaying 21 to 30 of 32 total results