Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
The result is placed in the to argument, followed by a terminating null byte. (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() ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-hex-string.html
The result is placed in the to argument, followed by a terminating null byte. 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 ... unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
For a JSON column which has been updated such that its binary representation is the same as or larger than before, or if the update was not able to take advantage of a partial update, it returns 0; it returns NULL if the argument is NULL. If ...
https://dev.mysql.com/doc/refman/8.4/en/create-index.html
If a table contains no primary key, InnoDB automatically promotes the first UNIQUE NOT NULL index to the primary key. This is not supported for UNIQUE NOT NULL indexes that have functional key parts. A UNIQUE index permits multiple NULL values for ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
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. For information on establishing connections using command-line options, for ...
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/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. The name of the file that was loaded (the original ... The following sections provide details about what appears in the fixed and variable parts of the event data for each event ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The rules for NULL handling are described later in this section. \Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 11.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
The value can be NULL if the row refers to the union result of other rows. If this column is NULL (or undefined in JSON-formatted output), there are no relevant indexes. If key is NULL, MySQL found no index to use for executing the query more ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. Returns NULL if X is not in the range -1 to 1, or if X is NULL. mysql> SELECT ACOS(1); -> 0 mysql> SELECT ACOS(1.0001); -> NULL mysql> SELECT ACOS(0); -> 1.5707963267949 ASIN(X) Returns ...An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT ...