Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbindexscanoperation.html
For more information about the use of NdbIndexScanOperation, see Section 1.4.2.3.3, “Scan Operations”, and Section 1.4.2.3.4, “Using Scans to Update or Delete Rows”. Signature virtual int readTuples ( LockMode mode = LM_Read, Uint32 flags = ...NdbIndexScanOperation Class Overview NdbIndexScanOperation::BoundType NdbIndexScanOperation::end_of_bound() NdbIndexScanOperation::getDescending() NdbIndexScanOperation::get_range_no() NdbIndexScanOperation::getSorted() NdbIndexScanOperation::IndexBound NdbIndexScanOperation::readTuples() NdbIndexScanOperation::reset_bounds() NdbIndexScanOperation::setBound() NdbIndexScanOperation Class Overview Parent class NdbScanOperation Child classes None Description The NdbIndexScanOperation class represents a scan operation using an ordered ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
A session that performs updates that match many rows in the WHERE clause might want to use statement-based logging because it is more efficient to log a few statements than many rows. When using STATEMENT mode, the binlog_format system variable is ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utils-copy.html
The utilities convert columns with data types that are not safe to be stored in text form (such as BLOB) to Base64. The default is true if stdout is a terminal (tty), such as when MySQL Shell is in interactive mode, and false otherwise. For other ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an autoincremented hidden key, i.e. NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. The ...
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/ndbapi/en/ndb-ndbtransaction.html
execute() operates in one of the three modes listed here: NdbTransaction::NoCommit: Executes operations without committing them. The GCI for a scan transaction is undefined, since no updates are performed in scan transactions. The mask, if not NULL, ...A transaction consists of a list of operations represented by the NdbOperation class, or by one of its subclasses—NdbScanOperation, NdbIndexOperation, or ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-transaction-tables.html
INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. Transaction 2 does not start until a transactional table is accessed, despite the intervening updates to nontransactional tables. To selectively examine transaction history, ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.67 savePersistentAll(Iterable<?>) Parameter Description instances the instances to update 4.3.1.22.28 setLockMode(LockMode) public abstract void setLockMode(LockMode lockmode); Set the lock mode for read operations. Inserts, deletes, loads, ...Session extends AutoCloseable so it can be used in the try-with-resources ...