PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-operator-functions.html
If the first argument is 'point_circle', 'join_round', 'join_miter', or 'end_round', the points_per_circle argument must be given as a positive numeric value. If the fractional_distance argument is 1.0, the result may not be exactly the last point ... OpenGIS proposes a number of functions that can produce ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
mle_set_session_state() The MLE component provides this function as a means for determining the rules in effect during the current session for converting MySQL integer types (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT) and MySQL decimal types ... For ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html
DecimalType consists of a JSON key-value pair whose key is DecimalType, and whose possible values and their effects are listed here: mysql.DecimalType.STRING: Convert MySQL decimal values (DECIMAL and its alias NUMERIC) to JavaScript String values.
https://dev.mysql.com/doc/refman/9.7/en/string-literals.html
For both types of strings, comparisons are based on the numeric values of the string unit. For binary strings, the unit is the byte; comparisons use numeric byte values. For nonbinary strings, the unit is the character and some character sets ... A ...
https://dev.mysql.com/doc/refman/9.7/en/where-optimization.html
If all columns used from the index are numeric, only the index tree is used to resolve the query. This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations ...
https://dev.mysql.com/doc/refman/9.7/en/window-functions-frames.html
For expr PRECEDING (and expr FOLLOWING), expr can be a ? parameter marker (for use in a prepared statement), a nonnegative numeric literal, or a temporal interval of the form INTERVAL val unit. (For details about the permitted units specifiers, see ... The definition of a window used with a window function can include a frame ...
https://dev.mysql.com/doc/refman/9.7/en/arithmetic-functions.html
For information about handling of overflow in numeric expression evaluation, see Section 13.1.7, “Out-of-Range and Overflow Handling”. (See Section 13.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 Division by zero produces ... Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filter-definitions.html
Arguments can refer to predefined variables, event fields, or string or numeric constants. For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
Characters not valid as XML characters are encoded using numeric character references. Characters not valid as XML characters are encoded using numeric character references. Important The audit_log plugin is deprecated, and is being replaced by the ...
https://dev.mysql.com/doc/refman/9.7/en/change-replication-source-to.html
SOURCE_LOG_FILE must include the numeric suffix of a specific binary log file that is available on the source server, for example, SOURCE_LOG_FILE='binlog.000145'. SOURCE_LOG_POS is the numeric position for the replica to start reading in that file.