MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 281 to 290 of 296 total results

B.3.4.8 Problems with Floating-Point Values

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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.11 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/9.7/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.30 SHOW PROCEDURE CODE Statement

https://dev.mysql.com/doc/refman/9.7/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/9.7/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, ...

27.3.7.3 Working with Data and Metadata

https://dev.mysql.com/doc/refman/9.7/en/srjs-api-data-metadata.html

This includes the names of the columns in the result set. If the result set is not empty, the contents of each row are printed in the order obtained; otherwise, the function gets the number of rows affected by the statement and the value of the last ...

27.3.5 JavaScript Stored Programs—Session Information and Options

https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html

For general information about stored routines in MySQL, see Section 27.2, “Using Stored Routines”. The MLE component provides a number of loadable functions for working with MLE user sessions. These functions are listed and described here: ...

15.6.2 Statement Labels

https://dev.mysql.com/doc/refman/9.7/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 ...

Displaying 281 to 290 of 296 total results