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/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
If you set the options to NULL, the data loads in normal mode by default. After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
Return value A pointer to the table, or NULL if there is no table with the name supplied. This means that they cannot be accessed by MySQL clients, and that they cannot be replicated. For these reasons, it is often preferable to avoid working with ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
If this variable is not set, its default value is NULL, which means that the server permits the default set of ciphersuites. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometry.html
Exterior, interior, and boundary of an empty geometry are not defined (that is, they are represented by a NULL value). It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1057; Symbol: HW_ER_UNEXPECTED_NULL_JOIN Message: Root-level UNION ALL - unexpected NULL JOIN under STREAM Access Path. Workaround: Equality or NULL-safe equality should be present in the JOIN predicate. Error number: 1113; Symbol: ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-routines-table.html
If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is a stored procedure, this value is NULL. If the routine is ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
A value of NULL means “any plugin.” In the latter case, whatever plugin the client uses will do. The value is represented as a string at most MYSQL_USER_NAME_LENGTH bytes long, plus a terminating null. external_user: The server sets this to the ... Declare the server-side plugin with the usual general descriptor format that is used for all server plugin types (see Section 4.4.2.1, “Server Plugin Library and Plugin ...
https://dev.mysql.com/doc/ndbapi/en/ndbapi-examples-array-simple.html
This program inserts CHAR, VARCHAR, and BINARY column data into a table by constructing aRef objects using local functions. It then reads the columns back and extracts the data from them using local functions. See Section 2.5.15, “Common Files ...