https://dev.mysql.com/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 12.25.3, “Expression Handling”, and Section 12.25.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/signal.html
Item Name Definition --------- ---------- CLASS_ORIGIN VARCHAR(64) SUBCLASS_ORIGIN VARCHAR(64) CONSTRAINT_CATALOG VARCHAR(64) CONSTRAINT_SCHEMA VARCHAR(64) CONSTRAINT_NAME VARCHAR(64) CATALOG_NAME VARCHAR(64) SCHEMA_NAME VARCHAR(64) TABLE_NAME ...
https://dev.mysql.com/spatial-geojson-functions.html
The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...
https://dev.mysql.com/string-functions.html
It is treated as an unsigned integer, so a value of −1 is effectively the same as 64. For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to ...
https://dev.mysql.com/sys-ps-is-thread-instrumented.html
Returns YES or NO to indicate whether Performance Schema instrumentation for a given connection ID is enabled, UNKNOWN if the ID is unknown, or NULL if the ID is NULL. This is a value of the type given in the PROCESSLIST_ID column of the ...
https://dev.mysql.com/sys-ps-thread-account.html
in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. The value should match the THREAD_ID column from some Performance ...
https://dev.mysql.com/sys-ps-thread-trx-info.html
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 already ...
https://dev.mysql.com/sys-version-major.html
This function returns the major version of the MySQL server. mysql> SELECT VERSION(), sys.version_major(); +--------------+---------------------+ | VERSION() | sys.version_major() | +--------------+---------------------+ | 8.0.13-debug | 8 | ...
https://dev.mysql.com/sys-version-minor.html
This function returns the minor version of the MySQL server. mysql> SELECT VERSION(), sys.version_minor(); +--------------+---------------------+ | VERSION() | sys.version_minor() | +--------------+---------------------+ | 8.0.13-debug | 0 | ...
https://dev.mysql.com/sys-version-patch.html
This function returns the patch release version of the MySQL server. mysql> SELECT VERSION(), sys.version_patch(); +--------------+---------------------+ | VERSION() | sys.version_patch() | +--------------+---------------------+ | 8.0.13-debug | 13 ...
