PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable users or ...
https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/9.7/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with a spatial index. The default setting is calculated by the number of available logical processors on the system divided by 8, with a minimum default value of 4. The maximum setting is 256, which ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/9.7/en/analyze-table.html
Histogram generation applies to columns of all data types except geometry types (spatial data) and JSON. ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ...
https://dev.mysql.com/doc/refman/9.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. Its proper operation requires that the help tables in the mysql database be initialized with help topic information (see Section 7.1.17, ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger ...
https://dev.mysql.com/doc/refman/9.7/en/check-table.html
CHECK TABLE functionality for InnoDB SPATIAL indexes includes an R-tree validity check and a check to ensure that the R-tree row count matches the clustered index. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/user-variables.html
For example, a value having a temporal or spatial data type is converted to a binary string. You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-indexes-table.html
0 = nonunique secondary index; 1 = automatically generated clustered index (GEN_CLUST_INDEX); 2 = unique nonclustered index; 3 = clustered index; 32 = full-text index; 64 = spatial index; 128 = secondary index on a virtual generated column. For ...