PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
PS_CURRENT_THREAD_ID() Returns a BIGINT UNSIGNED value representing the Performance Schema thread ID assigned to the current connection. PS_THREAD_ID(connection_id) Given a connection ID, returns a BIGINT UNSIGNED value representing the Performance ... As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ... | VALUES row_constructor_list } REPLACE [LOW_PRIORITY | DELAYED] ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-id.html
Parameters in_connection_id BIGINT UNSIGNED: The ID of the connection for which to return the thread ID. Note As of MySQL 8.0.16, ps_thread_id() is deprecated and subject to removal in a future MySQL version. Applications that use it should be ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-auto-increment-columns.html
For example, for a column with a bigint(20) unsigned column type, the data type is just bigint. This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/audit-log-reference.html
Unless those objects are installed, the audit_log plugin operates in legacy mode (deprecated in MySQL 8.0.34). Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data.
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...