Search Results
https://dev.mysql.com/doc/refman/8.4/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
row *************************** Table: auto_0 Create Table: CREATE TABLE `auto_0` ( `c1` varchar(50) DEFAULT NULL, `c2` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci 1 row in set (0.00 sec) mysql> SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/date-calculations.html
You determine which animals these are by checking whether the death value is NULL. MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The value is non-NULL only for accounts that use a MySQL built-in authentication plugin (mysql_native_password which is deprecated, sha256_password which is deprecated, or caching_sha2_password). The value is NULL for other accounts, such as those ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
This is NULL if the column has an explicit default of NULL, or if the column definition includes no DEFAULT clause. The value is YES if NULL values can be stored in the column, NO if not. (A UNIQUE index permits multiple NULL values, but you can ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-buffer-pool-tables.html
Example 17.6 Querying System Data in the INNODB_BUFFER_PAGE Table This query provides an approximate count of pages that contain system data by excluding pages where the TABLE_NAME value is either NULL or includes a slash / or period . The InnoDB ...
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/keyring-service.html
If there is no user context, this value can be NULL. Syntax: bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: key_id, user_id: Null-terminated strings that as a pair form a ...
https://dev.mysql.com/doc/refman/8.4/en/limit-optimization.html
row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: 100.00 Extra: Using index condition; Using filesort See also Section 10.9.2, ... If you ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Namespace and lock names must be non-NULL, nonempty, and have a maximum length of 64 characters. A namespace or lock name specified as NULL, the empty string, or a string longer than 64 characters results in an ER_LOCKING_SERVICE_WRONG_NAME error.