MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 66 of 66 total results

« Previous
5
6
7
Next »

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

26.2.3.1 RANGE COLUMNS partitioning

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

RANGE COLUMNS partitioning columns are not restricted to integer columns; string, DATE and DATETIME columns can also be used as partitioning columns. Range columns partitioning is similar to range partitioning, but enables you to define partitions ...

26.2.3 COLUMNS Partitioning

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

The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...

26.6 Restrictions and Limitations on Partitioning

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

This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...

14.5 Flow Control Functions

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

Otherwise, for a mix of temporal types, the result is DATETIME. 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 there is no ELSE part.

1.2.2 The Main Features of MySQL

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

Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...