https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/glossary.html
Often used to save space and improve query performance by replacing repeated strings with numeric IDs, in a normalized data design. Thus, it is typically better to use arbitrary numeric values to form a synthetic key, for example using an ... These ...
https://dev.mysql.com/mysql-cluster-programs-ndb-restore.html
--backupid=#, -b Property Value Command-Line Format --backupid=# Type Numeric Default Value none This option is used to specify the ID or sequence number of the backup, and is the same number shown by the management client in the Backup backup_id ...
https://dev.mysql.com/secure-client-programming.html
The simplest way to protect from this type of attack is to use single quotation marks around the numeric constants: SELECT * FROM table WHERE ID='234'. In a numeric context, MySQL automatically converts this string to a number and strips any ...
https://dev.mysql.com/c-api-server-client-versions.html
The string and numeric forms of the MySQL server version are available at compile time as the values of the MYSQL_SERVER_VERSION and MYSQL_VERSION_ID macros, and at runtime as the values of the mysql_get_server_info() and mysql_get_server_version() ...The MySQL client library version depends on the type of distribution that provides the library: For MySQL distributions, the client library version is the MySQL ...
https://dev.mysql.com/columns-table.html
The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The ...
https://dev.mysql.com/load-data.html
These are the same values that result if you assign an empty string explicitly to a string, numeric, or date or time type explicitly in an INSERT or UPDATE statement. For example, if sql_mode is set to TRADITIONAL, conversion of an empty value or a ...INTO Syntax”.) To write data from a table to a file, use SELECT ...
https://dev.mysql.com/mathematical-functions.html
mysql> SELECT CEILING(1.23); -> 2 mysql> SELECT CEILING(-1.23); -> -1 For exact-value numeric arguments, the return value has an exact-value numeric type. mysql> SELECT FLOOR(1.23), FLOOR(-1.23); -> 1, -2 For exact-value numeric arguments, the ...
https://dev.mysql.com/mysql-cluster-shm-definition.html
Group Table 22.306 This table provides type and value information for the Group shared memory configuration parameter Property Value Version (or later) NDB 8.0.13 Type or units numeric Default 35 Range 0-200 Restart Type N Determines the group ...
https://dev.mysql.com/parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in SQL functions or user-defined ...
