Search Results
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact values. A floating-point value as written in an SQL statement may not be the same as the value represented internally. Attempts to treat ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). This identifier is unique not only to the server on which it originated, but is unique across ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
Before you proceed, ensure that you have: Configured the source with the necessary configuration properties. Obtained the source status information, or a copy of the source's binary log index file made during a shutdown for the data snapshot. On the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-mysqldump.html
Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 6.5.4, “mysqldump — A Database ...
https://dev.mysql.com/doc/refman/8.4/en/replication-upgrade.html
When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to replication. For general information and instructions for upgrading a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
After the server accepts a connection, it enters Stage 2 of access control. For each request that you issue through the connection, the server determines what operation you want to perform, then checks whether your privileges are sufficient. This ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply ...