MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 71 to 80 of 81 total results

https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-functions.html

The return value is a string of five hexadecimal numbers separated by dashes. mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the result ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

https://dev.mysql.com/doc/refman/8.0/en/myisampack.html

pre-space The number of decimal columns that are stored with leading spaces. When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual ...

6.5.1.1 mysql Client Options

https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html

--binary-as-hex Command-Line Format --binary-as-hex Type Boolean Default Value (≥ 8.0.19) FALSE in noninteractive mode Default Value (≤ 8.0.18) FALSE When this option is given, mysql displays binary data using hexadecimal notation (0xvalue). In ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...

B.3.4.7 Solving Problems with No Matching Rows

https://dev.mysql.com/doc/refman/8.0/en/no-matching-rows.html

If you are comparing FLOAT or DOUBLE columns with numbers that have decimals, you cannot use equality (=) comparisons. If you have a complicated query that uses many tables but that returns no rows, you should use the following procedure to find ...

14.6 Numeric Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/numeric-functions.html

Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...

13.1.6 Numeric Type Attributes

https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html

As of MySQL 8.0.17, the UNSIGNED attribute is deprecated for columns of type FLOAT, DOUBLE, and DECIMAL (and any synonyms) and you should expect support for it to be removed in a future version of MySQL. MySQL supports an extension for optionally ...

10.9.6 Optimizer Statistics

https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html

The value is one of int, uint (unsigned integer), double, decimal, datetime, or string (includes character and binary strings). The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in ...

13.1.7 Out-of-Range and Overflow Handling

https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html

If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...

26.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns.html

(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...

26.6.3 Partitioning Limitations Relating to Functions

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-functions.html

Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the INT types or DECIMAL. This section discusses limitations in MySQL Partitioning relating specifically to functions used in ...

Displaying 71 to 80 of 81 total results