PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
If the routine name is the same as the name of a built-in SQL function, a syntax error occurs unless you use a space between the name and the following parenthesis when defining the routine or invoking it later. IF NOT EXISTS prevents an error from ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html
A password for the superuser is set and stored in the error log file. If something goes wrong during installation, you might find debug information in the error log file /var/log/mysqld.log. See Section B.3.2.16, “File Not Found and Similar ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Trying to set any other scope for this privilege results in an error. Grant this privilege to accounts that are assigned using CHANGE REPLICATION SOURCE TO (from MySQL 8.0.23) or CHANGE MASTER TO (before MySQL 8.0.23) to provide a security context ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
perror A utility that displays the meaning of system or MySQL error codes. mysqlsh MySQL Shell is an advanced client and code editor for MySQL Server. Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...In other cases, when a collation description is generally correct but contains some unknown tags, the collation is initialized and is available for ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
IF NOT EXISTS has the same meaning for CREATE EVENT as for CREATE TABLE: If an event named event_name already exists in the same schema, no action is taken, and no error results. row *************************** Level: Note Code: 1588 Message: Event ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/insert-on-duplicate.html
Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode. If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-find.html
mysql-js> db.countryinfo.find() [ { "GNP": 828, "Code:": "ABW", "Name": "Aruba", "IndepYear": null, "geography": { "Continent": "North America", "Region": "Caribbean", "SurfaceArea": 193 }, "government": { "GovernmentForm": "Nonmetropolitan ... You ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-find.html
mysql-py> db.countryinfo.find() [ { "GNP": 828, "Code:": "ABW", "Name": "Aruba", "IndepYear": null, "geography": { "Continent": "North America", "Region": "Caribbean", "SurfaceArea": 193 }, "government": { "GovernmentForm": "Nonmetropolitan ... You ...