Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Importing a table that does not explicitly define a row format results in a schema mismatch error if the innodb_default_row_format setting on the source server differs from the setting on the destination server. The row format of a table determines ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
If you mix comma joins with the other join types when there is a join condition, an error of the form Unknown column 'col_name' in 'on clause' may occur. Because t1.i1 is not a column in either of the operands, the result is an Unknown column ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-oci-component.html
Check the server error log, correct the configuration issues, and use the ALTER INSTANCE RELOAD KEYRING statement to reload the configuration. Note The Oracle Cloud Infrastructure Vault keyring component is included in MySQL Enterprise Edition, a ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-system-variables.html
If an attempted runtime assignment to keyring_okv_conf_dir results in an error, the variable value and keyring operation remain unchanged. These variables are unavailable unless the appropriate keyring plugin is installed (see Section 8.4.4.3, ...
https://dev.mysql.com/doc/refman/8.4/en/load-xml.html
If the file cannot be found, the following error results: ERROR 2 (HY000): File '/person.xml' not found (Errcode: 2) The ROWS IDENTIFIED BY '<person>' clause means that each <person> element in the XML file is considered equivalent to a row in the ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT COT(12); -> -1.5726734063977 mysql> SELECT COT(0); -> out-of-range error CRC32(expr) Computes a ...