PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-info.html
row *************************** id: 1 select_type: SIMPLE table: trb1 partitions: p0,p1,p2,p3 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 10 Extra: Using filesort In this case, all four partitions are searched. row ... This ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-instruments-table.html
row *************************** NAME: wait/synch/mutex/pfs/LOCK_pfs_share_list ENABLED: NO TIMED: NO PROPERTIES: singleton FLAGS: NULL VOLATILITY: 1 DOCUMENTATION: Components can provide their own performance_schema tables. row ... The ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. If you exceed the maximum allowed key length or specify less than the minimum, key generation fails and the result is ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions.html
If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as appropriate. When OFF is set, content encrypted by the legacy functions cannot be decrypted, and the function returns null output for ... In releases from MySQL 8.0.30, MySQL Enterprise Encryption's functions are provided by the MySQL component ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for statements received from any account that is a member of the group. If the value is non-NULL, the ...It ...
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
If either expr or pat is NULL, the result is NULL. Note Aggregate queries involving NOT LIKE comparisons with columns containing NULL may yield unexpected results. For example, consider the following table and data: CREATE TABLE foo (bar ... Table ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...