PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
If expr2 or expr3 produce a floating-point value, the result is a floating-point value. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if ...
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/data-types.html
For floating-point and fixed-point types, M is the total number of digits that can be stored (the precision). D applies to floating-point and fixed-point types and indicates the number of digits following the decimal point (the scale). MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Implicit defaults are defined as follows: For numeric types, the default is 0, with the exception that for integer or floating-point types declared with the AUTO_INCREMENT attribute, the default is the next value in the sequence. Data type ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
In addition, statements using results from floating-point math functions—which are hardware-dependent—are always considered unsafe (see Section 19.5.1.12, “Replication and Floating-Point Values”). The “safeness” of a statement in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/choosing-types.html
This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...