MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 71 to 80 of 87 total results

https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html

When a value saved to a column is truncated, such as saving 3.14159 in a DECIMAL(10,1) column, a warning is issued independently of any ON ERROR option. This section contains information about JSON functions that convert JSON data to tabular data.

11.3 Keywords and Reserved Words

https://dev.mysql.com/doc/refman/9.7/en/keywords.html

Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/9.7/en/known-issues.html

When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. This section lists known issues in recent versions of MySQL.

12.16 MySQL Server Locale Support

https://dev.mysql.com/doc/refman/9.7/en/locale-support.html

The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...

29.12.14.4 Performance Schema variables_metadata Table

https://dev.mysql.com/doc/refman/9.7/en/performance-schema-variables-metadata-table.html

The variables_metadata table shows, for each server system variable, its name, scope, type, range of values (where applicable), and description. VARIABLE_SCOPE The variable's scope; this is one of the values listed here: GLOBAL The variable is ...

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

https://dev.mysql.com/doc/refman/9.7/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/9.7/en/mysql-command-options.html

--binary-as-hex Command-Line Format --binary-as-hex Type Boolean Default Value FALSE in noninteractive mode When this option is given, mysql displays binary data using hexadecimal notation (0xvalue). In addition, output from the status (or \s) ...

B.3.4.7 Solving Problems with No Matching Rows

https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/numeric-type-attributes.html

UNSIGNED 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 specifying the display width of ...

Displaying 71 to 80 of 87 total results