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/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
Note In previous versions of MySQL, when evaluating an expression containing LEAST() or GREATEST(), the server attempted to guess the context in which the function was used, and to coerce the function's arguments to the data type of the expression ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/compilation-problems.html
If you do reconfigure, take note of the following: If CMake is run after it has previously been run, it may use information that was gathered during its previous invocation. When CMake starts, it looks for that file and reads its contents if it ...
https://dev.mysql.com/doc/refman/8.0/en/compiler-characteristics.html
The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. In some cases, the compiler used to build MySQL affects the features available for use. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
Note While a compressed table is read only, and you cannot therefore update or add rows in the table, DDL (Data Definition Language) operations are still valid. Compressed storage format is a read-only format that is generated with the myisampack ...
https://dev.mysql.com/doc/refman/8.0/en/connection-access.html
Note It is a common misconception to think that, for a given user name, all rows that explicitly name that user are used first when the server attempts to find a match for the connection. When you attempt to connect to a MySQL server, the server ...
https://dev.mysql.com/doc/refman/8.0/en/connectors-apis.html
Table 31.1 MySQL APIs and Interfaces Environment API Type Notes Ada GNU Ada MySQL Bindings libmysqlclient See MySQL Bindings for GNU Ada C C API libmysqlclient See MySQL 8.0 C API Developer Guide. MySQL Connectors provide connectivity to the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
row *************************** Level: Note Code: 1003 Message: /* select#1 */ select `test`.`t`.`ti` AS `ti` from `test`.`t` where (`test`.`t`.`ti` = 255) 1 row in set (0.00 sec) Floating- or fixed-point value. Comparisons between constants and ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
Note that, even with the use of this heuristic, the optimizer still explores a roughly exponential number of plans. The task of the query optimizer is to find an optimal plan for executing an SQL query. Because the difference in performance between ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible with MySQL 8.0. If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips ...