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/date-and-time-functions.html
row *************************** Level: Warning Code: 1411 Message: Incorrect datetime value: '00/00/0000' for function str_to_date Prior to MySQL 8.0.35, it was possible to pass an invalid date string such as '2021-11-31' to this function. In MySQL ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
For example, on Ubuntu Linux, use: sudo apt-get install libevent-dev If you installed MySQL from a source code release, libevent 1.4.12 is bundled with the package and is located at the top level of the MySQL source code directory. get BB VALUE BB ... This section describes how to set up the daemon_memcached plugin on a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/lock-order-tool.html
Within the server, the set of lock-related objects changes with implementation of new features and code refactoring for performance improvements. If the _trace_ variable is enabled, an error is printed to the logs. If lock_order is enabled, an error ... The MySQL server is a multithreaded application that uses numerous internal locking and lock-related primitives, such as mutexes, rwlocks (including prlocks and sxlocks), conditions, and ...
https://dev.mysql.com/doc/refman/8.0/en/selinux-troubleshooting.html
$> systemctl start mysql.service Job for mysqld.service failed because the control process exited with error code. If you configure the MySQL Server to use a non-default port, such as port 3307, and do not update the policy to reflect the change, ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/source-installation-prerequisites.html
On Unix-like systems, including Linux, you can check your system's version of make like this: $> make --version GNU Make 4.2.1 As of MySQL 8.0.26, MySQL 8.0 source code permits use of C++17 features. If you encounter build errors such as internal ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
For truncation of nonspace characters, you can cause an error to occur (rather than a warning) and suppress insertion of the value by using strict SQL mode. This means that, if the index requires unique values, duplicate-key errors occur for values ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.0/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. To keep code portable across databases, it is recommended that you use LEFT JOIN instead of ...
https://dev.mysql.com/doc/refman/8.0/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 ...