MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 231 to 240 of 246 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 value is one of int, decimal, real, char, or row. 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 ...

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 ...The ...

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

(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. Statement-based replication of ...

15.6.7.4 RESIGNAL Statement

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

Within a condition handler that catches a condition, one use for RESIGNAL alone is to perform some other actions, and then pass on without change the original condition information (the information that existed before entry into the handler). ERROR ...RESIGNAL may change some or all information before passing it ...

15.7.7.9 SHOW CREATE PROCEDURE Statement

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

row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...

15.7.7.27 SHOW PROCEDURE CODE Statement

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 ...

15.5 Prepared Statements

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

Other language interfaces can provide support for prepared statements that use the binary protocol by linking in the C client library, one example being the mysqli extension, available in PHP 5.0 and higher. Prepared Statements in SQL Scripts An ...

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

It is intended you call ps_setup_reload_saved() later within the same session as ps_setup_save() because the configuration is saved in TEMPORARY tables. Parameters in_timeout INT: How many seconds to wait to obtain the sys.ps_setup_save lock. This ...

Displaying 231 to 240 of 246 total results