Search Results
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
\Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 11.1.1, “String Literals”. This differs from the word NULL enclosed within FIELDS ENCLOSED BY characters, which is read as the string 'NULL'. With fixed-row ...Input File Character Set The file name must be given as a literal ...The file can be read from the server ...
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. column->path The -> operator serves as an alias for ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. Note The term “URI-like” signifies connection-string syntax that is ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Value is the catalog name: a length byte followed by that many bytes, plus a terminating null byte. It was replaced with Q_CATALOG_NZ_CODE in MySQL 5.0.4 because the terminating null is unnecessary. This variable is present only if the time zone ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
(In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string_quote() returns, the contents of to is a null-terminated string. The return value is ... unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
(In the worst case, each character may need to be encoded as using two bytes, and there must be room for the terminating null byte.) When mysql_real_escape_string() returns, the contents of to is a null-terminated string. The return value is the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
When mysql_hex_string() returns, the contents of to is a null-terminated string. The return value is the length of the encoded string, not including the terminating null byte. Return Values The length of the encoded string that is placed into to, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The operations performed include defining string column encodings, defining the secondary engine, and executing SECONDARY_LOAD operations. row *************************** id: 1 select_type: SIMPLE table: lineitem partitions: NULL type: ALL ... The ...
https://dev.mysql.com/doc/refman/8.4/en/group-by-modifiers.html
These rows have the country and products columns set to NULL. This row has the year, country, and products columns set to NULL. The NULL indicators in each super-aggregate row are produced when the row is sent to the client. For any column in the ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
(Depending on the nullability of the derived table, this can sometimes be simplified further to an inner join.) This can be done for a subquery which meets the following conditions: The subquery does not make use of any nondeterministic functions, ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...