Search Results
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
If a statement or condition item is not set by a statement that populates the diagnostics area, its value is 0 or the empty string, depending on the item data type. RETURNED_SQLSTATE: A string that indicates the SQLSTATE value for the condition.
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Signature int dropEvent ( const char* name, int force = 0 ) Parameters This method takes two parameters: The name of the event to be dropped, as a string. Signature const Event* getEvent ( const char* eventName ) Parameters The eventName, a string ...This means that they cannot be accessed by MySQL clients, and that they cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
SUBPARTITION_NAME If the PARTITIONS table row represents a subpartition, the name of subpartition; otherwise NULL. For partitions whose PARTITION_METHOD is other than RANGE or LIST, this column is always NULL. However, the values of the ...Each row ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-functions.html
mysql> SELECT IFNULL(1,0); -> 1 mysql> SELECT IFNULL(NULL,10); -> 10 mysql> SELECT IFNULL(1/0,10); -> 10 mysql> SELECT IFNULL(1/0,'yes'); -> 'yes' The default return type of IFNULL(expr1,expr2) is the more “general” of the two expressions, in ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() ...
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 ...(Bug #70550, Bug #17592990) The names of these files are listed here: array_adapter.hpp: Contains utility classes for converting between C++ style strings or byte arrays and the format used by NDB internally for VARCHAR, CHAR, and VARBINARY ...
https://dev.mysql.com/doc/internals/en/transformation-scalar-in.html
On a value request (one of val, val_int, or val_str methods) it evaluates the left expression of the IN by storing its value in a cache item (one of Item_cache* items), then it tests the cache to see whether it is NULL. If left expression (cache) is ... To rewrite a scalar IN subquery, the Item_in_subselect::single_value_transformer method is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-online-add-node-example.html
This should be similar to what is shown here, where password is the MySQL root password for a given MySQL server instance: $> mysqladmin -uroot -ppassword shutdown 081208 20:19:56 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-optimization.html
row *************************** Table: accounts Non_unique: 0 Key_name: ACCOUNT Seq_in_index: 1 Column_name: USER Collation: NULL Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: HASH Comment: Index_comment: Visible: YES ...