MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 51 to 60 of 67 total results

28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table

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

For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier representing the table associated with the column; the same ...

15.7.3.1 ANALYZE TABLE Statement

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

ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...

15.1.18 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/9.7/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...

15.1.17 CREATE JSON DUALITY VIEW Statement

https://dev.mysql.com/doc/refman/9.7/en/create-json-duality-view.html

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE}] [DEFINER = user] [SQL SECURITY {DEFINER | INVOKER}] JSON [RELATIONAL] DUALITY VIEW [IF NOT EXISTS] [schema_name.]view_name AS json_duality_select_statement json_duality_select_statement: SELECT ...

15.1.24.9 Secondary Indexes and Generated Columns

https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html

A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns.

13.6 Data Type Default Values

https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html

Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...

13.4.2.11 MultiLineString Class

https://dev.mysql.com/doc/refman/9.7/en/gis-class-multilinestring.html

A MultiLineString is a MultiCurve geometry collection composed of LineString elements. MultiLineString Examples On a region map, a MultiLineString could represent a river system or a highway system.

13.4.2.13 MultiPolygon Class

https://dev.mysql.com/doc/refman/9.7/en/gis-class-multipolygon.html

A MultiPolygon is a MultiSurface object composed of Polygon elements. MultiPolygon Examples On a region map, a MultiPolygon could represent a system of lakes. MultiPolygon Assertions A MultiPolygon has no two Polygon elements with interiors that ...

13.4.2.12 MultiSurface Class

https://dev.mysql.com/doc/refman/9.7/en/gis-class-multisurface.html

A MultiSurface is a geometry collection composed of surface elements. MultiSurface Assertions Surfaces within a MultiSurface have no interiors that intersect. Surfaces within a MultiSurface have boundaries that intersect at most at a finite number ...

7.1.8 Server System Variables

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

Displaying 51 to 60 of 67 total results