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/partitioning-handling-nulls.html
Even though it is permitted to use NULL as the value of an expression that must otherwise yield an integer, it is important to keep in mind that NULL is not a number. Partitioning in MySQL does nothing to disallow NULL as the value of a ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-replication-asynchronous-connection-failover-managed-table.html
For example: {"Primary_weight": 80, "Secondary_weight": 60} Primary_weight: Integer between 0 and 100. This table holds configuration information used by the replica's asynchronous connection failover mechanism to handle managed groups, including ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
(In this case, an implicit CAST(? AS derived_type) is performed.) The derived type and actual type of the parameter are both INTEGER and have the same sign. The parameter's derived type is DECIMAL and its actual type is either DECIMAL or INTEGER.
https://dev.mysql.com/doc/refman/9.7/en/replication-delayed.html
SQL_Remaining_Delay: When Replica_SQL_Running_State is Waiting until SOURCE_DELAY seconds after master executed event, this field contains an integer indicating the number of seconds left of the delay. MySQL supports delayed replication such that a ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-geohash-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text string. Geohash values are ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
mle_set_session_state() The MLE component provides this function as a means for determining the rules in effect during the current session for converting MySQL integer types (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT) and MySQL decimal types ... For ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-column.html
The Column object represents the column metadata in a result set. Column has the methods listed here: getFractionalDigits(): Gets the fractional digits of the column value, if applicable. getCharacterSetName(): Retrieves the name of the character ...
https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-materialization.html
For example, the optimizer might be able to use materialization if both expressions are integer or both are decimal, but cannot if one expression is integer and the other is decimal. The optimizer uses materialization to enable more efficient ...