Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-role.html
DROP ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. By default, an error occurs if you try to drop a role that does not exist. If the IF EXISTS clause is given, the statement produces a warning for each ...DROP ROLE removes one or more roles (named collections of ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-boolean.html
Use of multiple operators on a single search word returns a syntax error to standard out. Specifying a trailing plus or minus sign causes InnoDB to report a syntax error. MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-configuring-instances.html
The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group Replication. It might work, but chances are that the operations race and then the act of joining the group ends up in an error or a time out. If the group members have a value set for one of these system variables, and a joining member has a different value set for it, the joining member cannot join the group and an error message is ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-responses-failure-partition.html
When the timeout specified by group_replication_unreachable_majority_timeout elapses, all pending transactions that have been processed by the member and the others in the minority group are rolled back, and the servers in that group move to the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-limits.html
Attempting to use an index key prefix length that exceeds the limit returns an error. ERROR 1070 (42000): Too many key parts specified; max 16 parts allowed The maximum row size, excluding any variable-length columns that are stored off-page, is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Fixed-length columns greater than or equal to 768 bytes are encoded as variable-length columns, which can be stored off-page. Fixed-length columns greater than or equal to 768 bytes are encoded as variable-length columns, which can be stored ... The ...
https://dev.mysql.com/doc/refman/8.4/en/json-utility-functions.html
If the value is not a JSON document, or if it cannot be parsed as one, the function fails with an error. If json_val is not NULL, and neither is a valid JSON document nor can be successfully parsed as one, an error results. An error results when ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
If component_keyring_encrypted_file cannot find the configuration file, an error results, and the component cannot initialize. If an error occurs, server startup fails and the administrator must correct any issues indicated by diagnostics in the ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-file-component.html
If an error occurs, server startup fails and the administrator must correct any issues indicated by diagnostics in the server error log. The component_keyring_file keyring component stores keyring data in a file local to the server host. Warning ...