Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-datetime-null.html
As such, when assigning values from a query to a DateTime variable, you must first check whether the value is in fact NULL.
https://dev.mysql.com/doc/internals/en/optimizer-late-nulls-filtering.html
Before performing an index lookup, we determine whether any of the expri values is NULL. This optimization reuses the null_rejecting attribute produced by the early NULLs filtering code (see Section 7.3.1.1, “Early NULLs Filtering”). Suppose we ...
https://dev.mysql.com/doc/internals/en/optimizer-nulls-filtering.html
This section discusses the NULLs filtering optimization used for ref and eq_ref joins.
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
A locking service name was specified as NULL, the empty string, or a string longer than 64 characters. Use 'mysqld --thread_stack=#' to specify a bigger stack if needed Error number: 1120; Symbol: ER_WRONG_OUTER_JOIN_UNUSED; SQLSTATE: 42000 Message: ... The MySQL server writes some error messages to its error log, and sends others to client ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string function is given a binary string as an argument, the ...For ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). A string object that can have only one ...If ...
https://dev.mysql.com/doc/internals/en/strings-directory.html
Many of the files in this subdirectory are equivalent to well-known functions that appear in most C string libraries. On the other hand, some of the files are MySQL additions or improvements. Often the MySQL changes are attempts to optimize the ...
https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
A string is a sequence of bytes or characters, enclosed within either single quote (') or double quote (") characters. Examples: 'a string' "another string" Quoted strings placed next to each other are concatenated to a single string. The following ...It has a character set other than binary and a collation that is compatible with the character ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic describes how to encode string columns to improve the performance of queries that access them. This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding ...To learn how to download the sample database, see AirportDB Analytics ...