Search Results
https://dev.mysql.com/doc/refman/8.4/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. An implication of the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A range of GTIDs originating from the same server can be collapsed into a single expression, as shown here: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 The above example represents the first through fifth transactions originating on the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
When the replication SQL thread replicates a LOAD DATA statement, it extracts the file to be loaded from the relay log into temporary files, and then loads these into the table. This value is only appropriate if data is partitioned into multiple ...
https://dev.mysql.com/doc/refman/8.4/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new source, the data is ...Before ...
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. Upgrade the old source according to the procedure for a single ...
https://dev.mysql.com/doc/refman/8.4/en/request-access.html
This is where the privilege columns in the grant tables come into play. A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it ... After the server accepts a connection, it enters Stage 2 of access ...
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
FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is materialized rather than merged into the outer query. MySQL permits a subquery to refer to a stored ...