PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.2Mb
Man Pages (TGZ)
- 295.4Kb
Man Pages (Zip)
- 400.6Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds delimiter is recognized. The only delimiter recognized between a date and time part and a fractional seconds part is the decimal ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/8.0/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
For example, inserting the string '1999.0e-2' into an INT, FLOAT, DECIMAL(10,6), or YEAR column inserts the value 1999, 19.9921, 19.992100, or 1999, respectively. For the FLOAT and DECIMAL columns, the string-to-number conversion considers the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
Consider these aspects of memcached applications when adapting an existing MySQL schema or application to use the daemon_memcached plugin: memcached keys cannot contain spaces or newlines, because these characters are used as separators in the ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
Beginning with MySQL 8.0.33, numbers in the output of EXPLAIN ANALYZE and EXPLAIN FORMAT=TREE are formatted according to the following rules: Numbers in the range 0.001-999999.5 are printed as decimal numbers. Decimal numbers less than 1000 have ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. in_interval DECIMAL(20,2): The number of seconds (which can be fractional) to sleep between data collections. Dumps all Performance Schema data ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For other types, inverse aggregation is safe; this includes DECIMAL, which permits a fractional part but is an exact-value type. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profiling.html
Values are also truncated to 6 decimal places to display data in the same format as SHOW PROFILES and SHOW PROFILE statements. The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data ...