PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/9.7/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”.
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'] ...
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 ...
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 ...
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.
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 '', ...
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.
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 ...
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 ...