Search Results
https://dev.mysql.com/doc/refman/8.4/en/bit-functions.html
The result type depends on whether the arguments are evaluated as binary strings or numbers: Binary-string evaluation occurs when the arguments have a binary string type, and at least one of them is not a hexadecimal literal, bit literal, or NULL ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
If this mode is not enabled, division by zero inserts NULL and produces no warning. If this mode is enabled, division by zero inserts NULL and produces a warning. For INSERT IGNORE and UPDATE IGNORE, division by zero inserts NULL and produces a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-parallel-table.html
MySQL Shell's parallel table import utility util.importTable() provides rapid data import to a MySQL relational table for large data files. The utility analyzes an input data file, distributes it into chunks, and uploads the chunks to the target ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-failover.html
There are a number of techniques when using MySQL Replication with Global Transaction Identifiers (GTIDs) for provisioning a new replica which can then be used for scaleout, being promoted to source as necessary for failover. Each identifier ...
https://dev.mysql.com/doc/refman/8.4/en/window-functions-frames.html
For RANGE, the bound is the rows with values equal to the current row value minus expr; if the current row value is NULL, the bound is the peers of the row. For RANGE, the bound is the rows with values equal to the current row value plus expr; if ...
https://dev.mysql.com/doc/refman/8.4/en/show-replica-status.html
In MySQL 8.4, this field is NULL (undefined or unknown) if the replication applier thread is not running, or if the applier thread has consumed all of the relay log and the replication receiver thread is not running. (In older versions of MySQL, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
If you set the options to NULL, the data loads in normal mode by default. Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
SET NULL: Delete or update the row from the parent table and set the foreign key column or columns in the child table to NULL. Both ON DELETE SET NULL and ON UPDATE SET NULL clauses are supported. If you specify a SET NULL action, make sure that you ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
NdbOperation::branch_col_eq_null() Description Branch to a label in an interpreted program if the specified column is NULL. Signature int branch_col_eq_null ( Uint32 ColId, Uint32 Label ) Parameters ColId ID of the column to check. Beginning with ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-blobs-ndbrecord.html
*/ char buffer[10000]; NdbTransaction *myTrans= myNdb->startTransaction(); if (myTrans == NULL) APIERROR(myNdb->getNdbError()); NdbScanOperation *myScanOp= myTrans->scanTable(blob_record, NdbOperation::LM_Exclusive); if (myScanOp == NULL) ... This ...