MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 61 to 70 of 71 total results

12.17.3 Functions That Search JSON Values

https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html

Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. The functions in this section perform search operations on JSON values to ...

12.6 Numeric Functions and Operators

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

Table 12.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 ...

24.4.17 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table

https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html

1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, ...

11.1.7 Out-of-Range and Overflow Handling

https://dev.mysql.com/doc/refman/5.7/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 ...

22.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/5.7/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 ...

22.6.3 Partitioning Limitations Relating to Functions

https://dev.mysql.com/doc/refman/5.7/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 ...

22.1 Overview of Partitioning in MySQL

https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html

This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning restrictions and feature limitations, see Section 22.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...

22.2 Partitioning Types

https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html

This section discusses the types of partitioning which are available in MySQL 5.7. This type of partitioning assigns rows to partitions based on column values falling within a given range. For information about an extension to this type, RANGE ...

25.19.1 Query Profiling Using Performance Schema

https://dev.mysql.com/doc/refman/5.7/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 ...

14.16.3 InnoDB INFORMATION_SCHEMA System Tables

https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html

MB values are rounded to zero decimal spaces using the ROUND() function. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system tables. This information comes from the InnoDB internal system tables ...

Displaying 61 to 70 of 71 total results