https://dev.mysql.com/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/sys-diagnostics.html
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 disables binary logging during its execution by manipulating the session value of ...
https://dev.mysql.com/sys-ps-thread-id.html
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 will be removed in a future MySQL version. Applications that use it should be migrated to use ...
https://dev.mysql.com/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/writing-protocol-trace-plugins.html
It has this definition: struct st_trace_event_args { const char *plugin_name; int cmd; const unsigned char *hdr; size_t hdr_len; const unsigned char *pkt; size_t pkt_len; }; For different event types, the st_trace_event_args structure contains the ... MySQL supports the use of protocol trace plugins: client-side plugins that implement tracing of communication between a client and the server that takes place using the client/server ...
https://dev.mysql.com/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/c-api-binary-log-data-structures.html
The callback function, if used, should have this calling signature: void my_callback(MYSQL_RPL *rpl, unsigned char *packet_gtid_set); gtid_set_arg Either a pointer to GTID set data (if fix_gtid_set is NULL), or a pointer to a value to be made ... C ...
https://dev.mysql.com/c-api-prepared-statement-type-conversions.html
But the binary representation of any TINYINT value requires only 1 byte for storage, so you can supply a signed char variable in which to store the value and set is_unsigned to indicate that values are signed. Prepared statements transmit data ...
https://dev.mysql.com/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/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 ...
