Search Results
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
AND key_partN cmp constN; Here, const1, const2, … are constants, cmp is one of the =, <=>, or IS NULL comparison operators, and the conditions cover all index parts. For a BTREE index, an interval might be usable for conditions combined with AND, ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
This section describes the server options and system variables that you can use on replication source servers. You can specify the options either on the command line or in an option file. On the source and each replica, you must set the server_id ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
(You cannot treat these as null-terminated strings if field values may contain binary data, because such values may contain null bytes internally.) Rows are obtained by calling mysql_fetch_row(). char * name The name of the field, as a ... This ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-named-param.html
In the absence of named parameters, pass in NULL as the array of bind parameter names. It succeeds without any effect (in corner cases) if the bind argument count parameter is zero or if the bind array pointer is NULL. The unnamed parameter has NULL ... bool mysql_stmt_bind_named_param(MYSQL_STMT *stmt, MYSQL_BIND *binds, unsigned n_params, const char **names) Description mysql_stmt_bind_named_param() sets up unnamed and named (query attributes) bind parameters for prepared ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
You can indicate that a function returns NULL or that an error occurred. (To use the default for a member, leave it unchanged.) bool maybe_null xxx_init() should set maybe_null to 1 if xxx() can return NULL. The default value is 1 if any of the ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-aml-prepare-an-anomaly-detection-model.html
The data has a column, target, that has three possible values: 0 for normal, 1 for anomalous, and NULL for unlabeled. This topic describes how to prepare the data to use for two anomaly detection machine learning models: a semi-supervised anomaly ...
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/ndbapi/en/ndbapi-examples-common-files.html
*/ class ReadOnlyArrayAdapter { public: ReadOnlyArrayAdapter() {} enum ErrorType {Success, InvalidColumnType, InvalidArrayType, InvalidNullColumn, InvalidNullAttribute, InvalidNullaRef, BytesOutOfRange, UnknownError}; /* Return a C++ string from the ... In the NDB Cluster source distribution, the storage/ndb/ndbapi-examples directory storage/ndb/ndbapi-examples/common contains four header files with utilities for use in example NDB API ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-auto-increment-handling.html
An example follows, where c1 is an AUTO_INCREMENT column of table t1: INSERT INTO t1 (c1,c2) VALUES (1,'a'), (NULL,'b'), (5,'c'), (NULL,'d'); Another type of “mixed-mode insert” is INSERT ... To make this clear, consider an example that uses ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
NULL, 'NULL', and Empty Values: For a column named column_name, the NULL value, an empty string, and the string value 'NULL' are distinguished from one another in the output generated by this option as follows. Value: XML Representation: NULL ...