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/sys-ps-thread-trx-info.html
Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return transaction information. Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version-major.html
This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +------------------+---------------------+ | VERSION() | sys.version_major() | +------------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version-minor.html
This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +------------------+---------------------+ | VERSION() | sys.version_minor() | +------------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-version-patch.html
This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +------------------+---------------------+ | VERSION() | sys.version_patch() | +------------------+---------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
One way to avoid such problems is to use CAST() so that a value is not converted implicitly to a float-point number: mysql> SELECT CAST('9223372036854775807' AS UNSIGNED) = 9223372036854775806; -> 0 For more information about floating-point ... When ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
The syntax to change the value of group_concat_max_len at runtime is as follows, where val is an unsigned integer: SET [GLOBAL | SESSION] group_concat_max_len = val; The return value is a nonbinary or binary string, depending on whether the ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-ft-index-table-table.html
The INNODB_FT_INDEX_TABLE table provides information about the inverted index used to process text searches against the FULLTEXT index of an InnoDB table. Before querying it, set the value of the innodb_ft_aux_table system variable to the name ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
NOTE 11: The Unicode scalar value of a character is its code point treated as an unsigned integer.” If the character set is ucs2, comparison is byte-by-byte, but ucs2 strings should not contain surrogates, anyway. This section describes the ...
https://dev.mysql.com/doc/refman/5.7/en/choosing-types.html
For example, if an integer column is used for values in the range from 1 to 99999, MEDIUMINT UNSIGNED is the best type. For optimum storage, you should try to use the most precise type in all cases. Of the types that represent all the required ...