Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table.html
NOT NULL | NULL If neither NULL nor NOT NULL is specified, the column is treated as though NULL had been specified. In MySQL 8.4, only the InnoDB, MyISAM, and MEMORY storage engines support indexes on columns that can have NULL values. In other ...| ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/myisampack.html
When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-asynchronous-interface-usage.html
CREATE DATABASE db; USE db; CREATE TABLE test_table (id INT NOT NULL); INSERT INTO test_table VALUES (10), (20), (30); CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpass'; GRANT ALL ON db.* TO 'testuser'@'localhost'; Create a file named ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. mysql> SELECT DATABASE(); -> 'test' If there is no ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
This example illustrates the key differences between the old-style NdbRecAttr API and the newer approach using NdbRecord when performing some common tasks in an NDB API application. The source code can be found can be found in the file ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-system-variables.html
group_replication_preemptive_garbage_collection Command-Line Format --group-replication-preemptive-garbage-collection[=ON|OFF] System Variable group_replication_preemptive_garbage_collection Scope Global Dynamic Yes SET_VAR Hint Applies No Type ...
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
Returns NULL if any argument is NULL, or if the path argument does not identify a section of the target document. Returns NULL if any argument is NULL or no paths locate a value in the document. row *************************** id: 1 select_type: ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-constants.html
The default means that the automatic reconnection due to network failures is disabled. 4.3.1.14.19 DEFAULT_PROPERTY_MGM_STRICT_TLS public static final int DEFAULT_PROPERTY_MGM_STRICT_TLS = 0; The default value of the MGM TLS level property ...