MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 51 to 60 of 68 total results

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

14.19 Aggregate Functions

https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions-and-modifiers.html

They are often used with a GROUP BY clause to group values into subsets. For information about aggregate functions that operate on geometry values, see Section 14.16.12, “Spatial Aggregate Functions”.

3.5 Changes in MySQL 8.0

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html

Before upgrading to MySQL 8.0, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Changes marked as Incompatible change are incompatibilities with earlier versions of ...

7.1.8 Server System Variables

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html

The MySQL server maintains many system variables that affect its operation. Most system variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically at runtime using the SET ...

19.1.6.4 Binary Logging Options and Variables

https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html

Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which ...

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

10.9.6 Optimizer Statistics

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

The column_statistics data dictionary table stores histogram statistics about column values, for use by the optimizer in constructing query execution plans. The column_statistics table has these characteristics: The table contains statistics for ...

11.3 Keywords and Reserved Words

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

17.12.1 Online DDL Operations

https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html

Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table ...

28.3.36 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table

https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html

The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...

Displaying 51 to 60 of 68 total results