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/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
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 ...