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/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
JSON_UNQUOTE() returns a value with a data type of LONGTEXT, and the hidden generated column thus is assigned the same data type. MySQL cannot index LONGTEXT columns specified without a prefix length on the key part, and prefix lengths are not ...
https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html
LONGTEXT [CHARACTER SET charset_name] [COLLATE collation_name] A TEXT column with a maximum length of 4,294,967,295 or 4GB (232 − 1) characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-ndb-comment-options.html
This works for BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT, and JSON columns. This option can be applied to any blob column type supported by MySQL except TINYBLOB or TINYTEXT (BLOB, MEDIUMBLOB, LONGBLOB, TEXT, MEDIUMTEXT, LONGTEXT).
https://dev.mysql.com/doc/refman/9.7/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
The maximum supported length for a LONGTEXT value is 1073741799 (230 - 24 - 23 - 1) characters; for LONGBLOB, the maximum supported length is 2147483639 (231 - 28 - 1). Most MySQL data types are supported for MLE stored program input and output ...
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
For information about connection character sets, see Section 12.4, “Connection Character Sets and Collations”.) This means that such a conversion results in a character (nonbinary) string (a CHAR, VARCHAR, or LONGTEXT value), except in the case ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/9.7/en/blob.html
A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. They ...
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-thread-trx-info.html
Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and ...