MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 67 of 67 total results

« Previous
5
6
7
Next »

28.3.42 The INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS Table

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

17.12.1 Online DDL Operations

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

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

14.24 Miscellaneous Functions

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

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 mode. As a result, the address value for rows within each name group is ...

10.9.6 Optimizer Statistics

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

26.6 Restrictions and Limitations on Partitioning

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

19.1.6.4 Binary Logging Options and Variables

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