MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 271 to 280 of 285 total results

29.12.21.10 The user_defined_functions Table

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-defined-functions-table.html

The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. For information about operations that add or remove table rows, see Section ...

B.3.4.8 Problems with Floating-Point Values

https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html

Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...

15.6.5.6 REPEAT Statement

https://dev.mysql.com/doc/refman/8.0/en/repeat.html

[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...

19.5.1.1 Replication and AUTO_INCREMENT

https://dev.mysql.com/doc/refman/8.0/en/replication-features-auto-increment.html

Statement-based replication of AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values is carried out subject to the following exceptions: A statement invoking a trigger or function that causes an update to an AUTO_INCREMENT column is not replicated ...

15.6.7.4 RESIGNAL Statement

https://dev.mysql.com/doc/refman/8.0/en/resignal.html

RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...

15.7.7.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html

SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. It returns the exact string that can be used to re-create the named stored procedure. A similar statement, SHOW CREATE FUNCTION, displays information about stored functions (see ...

15.7.7.27 SHOW PROCEDURE CODE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-procedure-code.html

SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...

15.5 Prepared Statements

https://dev.mysql.com/doc/refman/8.0/en/sql-prepared-statements.html

Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...

15.6.2 Statement Labels

https://dev.mysql.com/doc/refman/8.0/en/statement-labels.html

[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...

30.4.4.14 The ps_setup_save() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html

This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...

Displaying 271 to 280 of 285 total results