Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-binary-log.html
Important Before enabling this variable, you must make certain that there are no dependencies between transactional and nontransactional tables; an example of such a dependency would be the statement INSERT INTO myisam_table SELECT * FROM ...Where ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-data-split.html
If the number of samples in the 80% subset is fewer than five, then five samples are inserted into the training dataset. For each class in the dataset, 80% of the samples go into the training dataset, and the remaining go into the testing dataset.
https://dev.mysql.com/doc/workbench/en/wb-forward-engineering-sql-scripts.html
Figure 9.36 SQL Export Options The SQL Export Options displays the following facilities: Output SQL Script File: To specify the output file name, enter it into the Output SQL Script File field, or use the Browse button to select a file. Don't create ... Forward engineering enables you to create a script of your database ...
https://dev.mysql.com/doc/internals/en/multi-resultset.html
In our case we inserted 2 rows, but only the affected_rows of the last INSERT statement is returned as part of the OK_Packet. 01 31 00 0c 3f 00 01 00 00 00 08 81 00 00 00 00 .1..?........... 05 00 00 03 fe 00 00 0a 00 02 00 00 04 01 31 05 ...
https://dev.mysql.com/doc/refman/8.4/en/atomic-ddl.html
An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes associated with a DDL operation into a single, atomic operation. Atomic DDL Characteristics The characteristics of atomic DDL statements ...The operation is either committed, with applicable changes persisted to the data dictionary, storage engine, and binary log, or is rolled back, even if the server halts during the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-js> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-in-tables.html
In the following example, a document is passed as the final value to be inserted into the Info column. mysql-py> db.city.insert().values( None, "San Francisco", "USA", "California", '{"Population":830000}') Select a Record You can issue a query with ... In MySQL, a table may contain traditional relational data, JSON values, or ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-variables.html
sql_mode is also replicated except for the NO_DIR_IN_CREATE mode; the replica always preserves its own value for NO_DIR_IN_CREATE, regardless of changes to it on the source. However, when mysqlbinlog parses a SET @@sql_mode = mode statement, the ...
https://dev.mysql.com/doc/refman/8.4/en/view-check-option.html
The check for v3 also fails: mysql> INSERT INTO v2 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v2' mysql> INSERT INTO v3 VALUES (2); ERROR 1369 (HY000): CHECK OPTION failed 'test.v3' . The WITH CHECK OPTION clause can be given for an ...It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
(Bug #107991, Bug #34454572) Partitioning: When inserting NOW() into a column not part of the partition key of a partitioned table, all partitions were retrieved, and no pruning occurred. (Bug #37506554) In order to use xxhash functions ...(Bug ...