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/select.html
Use of an unqualified * with other items in the select list may produce a parse error. (If you attempt to do so, the statement is rejected with the error Can't update table 'old_table' while 'new_table' is being created.) FOR SHARE and LOCK IN SHARE ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. The log_timestamps system variable controls the time zone of timestamps in messages written to the slow query log file (as well as to the general ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
To check for these issues, execute this command: mysqlcheck -u root -p --all-databases --check-upgrade If mysqlcheck reports any errors, correct the issues. To avoid upgrade errors, such views should be altered before upgrading. Failing to do so ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
If the data dictionary is out of date but the server is prevented from upgrading it, the server does not run, and exits with an error instead. For example: [ERROR] [MY-013381] [Server] Server shutting down because upgrade is required, yet prohibited ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_cursor_close The number of cursor-close messages received Mysqlx_cursor_fetch The number of cursor-fetch messages received ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. Please check these references before reporting gb2312 or gbk bugs: The MySQL gbk character set is ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. If the value of explain_format is JSON, EXPLAIN ANALYZE returns an error unless FORMAT=TREE is specified ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name } format_name: { TRADITIONAL | JSON | TREE } explainable_stmt: { select_stmt | TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
If an SRS definition specifies an authority code for the projection (which is recommended), an error occurs if the definition is missing mandatory parameters. SRID values must be unique, so if neither OR REPLACE nor IF NOT EXISTS is specified, an ...
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 ...