Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
If a larger value is given, only the lower 32 bits are used. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different ...
https://dev.mysql.com/doc/refman/8.4/en/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/doc/refman/8.4/en/spatial-reference-systems.html
Earth is a bit shorter in its North-South axis than its East-West axis, so a slightly flattened sphere is more correct, but perfect spheres permit faster calculations. A spatial reference system (SRS) for spatial data is a coordinate-based system ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). The string data types are CHAR, VARCHAR, ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point before comparison, which is not capable of representing all 64-bit integers exactly. When an ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, or BETWEEN operators, MySQL normally converts the string to an internal long integer for faster comparison (and also for a bit more “relaxed” ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Client also sends 1-byte capability, with RESIDENT_KEYS bit set to ON (if it is FIDO2 device) or OFF. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
MySQL is available for Microsoft Windows 64-bit operating systems only. There are different methods to install MySQL on Microsoft Windows: the MSI, the standard binary distribution (packaged as a compressed file) containing all of the necessary ...
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
You can use a quoted string ('ab'), hex string (X'6162', 0x6162), or bit value (b'nnnn'). To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
All internal ACL bitmask variables are now explicitly 32 bits (uint32_t). It was removed due to a critical issue that could stop the server from restarting following the creation of a very large number of tables (8001 or more). Now pruning continues ...