MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 241 to 250 of 257 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 ...The ...

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

(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/9.7/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.12 SHOW CREATE PROCEDURE Statement

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

https://dev.mysql.com/doc/refman/9.7/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/9.7/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 later. Prepared Statements in SQL Scripts An ...

27.3.7.3 Working with Data and Metadata

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

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 inserted ID. This includes the names of the columns in ...

27.3.5 JavaScript Stored Programs—Session Information and Options

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

stack_trace: If execution of the MLE stored program is unsuccessful, this contains a stack trace which may help in pinpointing the source of the error. mle_set_session_state() The MLE component provides this function as a means for determining the ... For general information about stored routines in MySQL, see Section 27.2, “Using Stored ...

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 241 to 250 of 257 total results