Search Results
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-restrictions.html
If binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE statements cannot be used inside transactions, procedures, functions, and triggers when GTIDs are in use on the server (that is, when the enforce_gtid_consistency ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/9.7/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. It is also important to note that the results vary depending on whether the operation is logged using statement-based or row-based binary logging ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/show-library-status.html
row *************************** Db: test Name: my_lib Type: LIBRARY Creator: jon@localhost Modified: 2025-03-21 08:42:17 Created: 2025-01-13 17:24:08 Comment: This is my_lib. SHOW LIBRARY STATUS [LIKE 'pattern' | WHERE expr] This statement provides ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-api-data-metadata.html
This includes the names of the columns in the result set. If the result set is not empty, the contents of each row are printed in the order obtained; otherwise, the function gets the number of rows affected by the statement and the value of the last ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-sqlerror.html
You can create an SqlError using the constructor shown here: new SqlError( sql_state: Number, message: String, error_number: Number ) The JavaScript stored procedure in the following example tries and throws an SqlError created using this ... When ...
https://dev.mysql.com/doc/refman/9.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-upgrade-rolling.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the server instances in an InnoDB Cluster, complete the following steps: Upgrade MySQL ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-innodb-cluster-working-with-clone.html
dba.createCluster() and MySQL Clone By default, when a new cluster is created on an instance where the MySQL Clone plugin is available, it is automatically installed and the cluster is configured to support cloning. The InnoDB Cluster recovery ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/upgrade-innodb-replicaset.html
On a Unix system, if you used the optional --directory bootstrap option, a self-contained installation is created with all generated directories and files at the location you selected when you bootstrapped the router. Navigate to this directory and ... To upgrade the instances in an InnoDB ReplicaSet, complete the following steps: Upgrade MySQL ...