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/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/9.7/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/9.7/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/9.7/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/9.7/en/srjs-examples.html
Because JavaScript treats a VECTOR value as an array (an instance of Float32Array), it is displayed using array format. This section contains examples illustrating a number of different aspects of using JavaScript programs under various ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/spatial-relation-functions-mbr.html
MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and g2. The return values 1 and 0 indicate true and false, respectively. The MBR (also known as the bounding ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. MySQL provides support ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
For example, if you insert NULL into an integer or floating-point column that has the AUTO_INCREMENT attribute, the next number in the sequence is inserted. The concept of the NULL value is a common source of confusion for newcomers to SQL, who ...