PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
If a statement or condition item is not set by a statement that populates the diagnostics area, its value is 0 or the empty string, depending on the item data type. RETURNED_SQLSTATE: A string that indicates the SQLSTATE value for the condition.
https://dev.mysql.com/doc/refman/5.7/en/gis-class-geometry.html
Geometry values of types (LineString, MultiPoint, MultiLineString) are either simple or nonsimple. Geometry values of types (LineString, MultiString) are either closed or not closed. Exterior, interior, and boundary of an empty geometry are not ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. If the routine is a stored procedure, this value is NULL. CHARACTER_OCTET_LENGTH For stored function string return values, the maximum length in ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-partitions-table.html
SUBPARTITION_NAME If the PARTITIONS table row represents a subpartition, the name of subpartition; otherwise NULL. For tables using other storage engines and which are not partitioned, this column is NULL. For partitions whose PARTITION_METHOD is ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
If replication stops due to an issue with an event in a replicated transaction, you can resume replication by skipping the failed transaction on the replica. Before skipping a transaction, ensure that the replication I/O thread is stopped as well ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns the arc sine of X, ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/5.7/en/json-attribute-functions.html
Returns NULL if any argument is NULL or the path argument does not identify a value in the document. The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...