Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
A spatial reference system (SRS) for spatial data is a coordinate-based system for geographic locations. There are different types of spatial reference systems: A projected SRS is a projection of a globe onto a flat surface; that is, a flat map.
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. For definitions of character ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables users to authenticate to MySQL Server using WebAuthn authentication.
https://dev.mysql.com/doc/refman/8.4/en/xa-statements.html
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 COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-1.html
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 in such cases, but with a warning printed in the error log stating that ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
Audit Log Notes Compilation Notes SQL Function and Operator Notes InnoDB Notes Optimizer Notes Packaging Notes Performance Schema Notes Bugs Fixed Audit Log Notes Fixed an issue related to audit log strategy. (Bug #38223011) Improved performance ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/installing.html
Install MySQL Enterprise Backup on each database server whose contents you intend to back up. Typically, you perform all backup and restore operations locally, by running mysqlbackup on the same server as the MySQL instance. MySQL Enterprise Backup ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-call-statements.html
This section describes prepared-statement support in the C API for stored procedures executed using CALL statements: Stored procedures executed using prepared CALL statements can be used in the following ways: A stored procedure can produce any ...