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/mysqld-server.html
This setting modifies certain aspects of SQL syntax and semantics, for example for compatibility with code from other database systems, or to control the error handling for particular situations. The following discussion covers these MySQL server ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.0/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future ...
https://dev.mysql.com/doc/refman/8.0/en/socket-pluggable-authentication.html
The source code for this plugin can be examined as a relatively simple example demonstrating how to write a loadable authentication plugin. For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html
When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from starting. This section helps you diagnose and correct some of these errors. Your first resource when troubleshooting server ...
https://dev.mysql.com/doc/refman/8.0/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/character-arrays.html
Binary collations need no <map> element because the character codes themselves provide the ordering. Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named ...
https://dev.mysql.com/doc/refman/8.0/en/charset-binary-set.html
Comparison and sorting are based on numeric byte values, rather than on numeric character code values (which for multibyte characters differ from numeric byte values). The binary character set is the character set for binary strings, which are ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
In terms of table content, conversion from utf8mb3 to utf8mb4 presents no problems: For a BMP character, utf8mb4 and utf8mb3 have identical storage characteristics: same code values, same encoding, same length. This section describes issues that ...