MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 68 of 68 total results

« Previous
5
6
7
Next »

28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table

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

13.4.2.12 MultiSurface Class

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

13.4.2.13 MultiPolygon Class

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

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

15.1.20 CREATE TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/create-table.html

| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...

15.1.20.9 Secondary Indexes and Generated Columns

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

15.1.15 CREATE INDEX Statement

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

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

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