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/gis-polygon-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_Centroid() handles its arguments as described in ...
https://dev.mysql.com/doc/refman/9.7/en/gis-wkb-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If the WKB or SRID argument is NULL, the return value is NULL. If the options argument is NULL, the return value is NULL. These functions take as ...
https://dev.mysql.com/doc/refman/9.7/en/group-by-handling.html
The query is invalid if name is not a primary key of t or a unique NOT NULL column. SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the ...
https://dev.mysql.com/doc/refman/9.7/en/help.html
If X is less than or equal to 0.0E0, the function returns NULL and a warning "Invalid argument for logarithm" is reported. URL: https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html Examples: mysql> SELECT LOG(2); -> 0.69314718055995 ... HELP 'search_string' The HELP statement returns online information from the MySQL Reference ...
https://dev.mysql.com/doc/refman/9.7/en/index-page-merge-threshold.html
row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `id` int(11) DEFAULT NULL, KEY `id_index` (`id`) COMMENT 'MERGE_THRESHOLD=40' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci Note A MERGE_THRESHOLD value ...If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-system-tables.html
row *************************** TABLE_ID: 71 NAME: col1 POS: 0 MTYPE: 6 PRTYPE: 1027 LEN: 4 HAS_DEFAULT: 0 DEFAULT_VALUE: NULL *************************** 2. row *************************** TABLE_ID: 71 NAME: col2 POS: 1 MTYPE: 2 PRTYPE: 524542 LEN: ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-troubleshooting-datadict.html
Information about table definitions is stored in the InnoDB data dictionary. If you move data files around, dictionary data can become inconsistent. If a data dictionary corruption or consistency issue prevents you from starting InnoDB, see Section ...
https://dev.mysql.com/doc/refman/9.7/en/insert.html
Warnings can occur under any of the following conditions: Inserting NULL into a column that has been declared NOT NULL. (For a single-row INSERT, no warning occurs when NULL is inserted into a NOT NULL column. INSERT [LOW_PRIORITY | DELAYED | ...
https://dev.mysql.com/doc/refman/9.7/en/locking-functions.html
Returns 1 if the lock was obtained successfully, 0 if the attempt timed out (for example, because another client has previously locked the name), or NULL if an error occurred (such as running out of memory or the thread was killed with mysqladmin ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these operations. This currently has the following formats: Base table: ...