PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/bit-type.html
For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same as assigning b'000101'. The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded ...
https://dev.mysql.com/doc/refman/5.7/en/collation-diagnostics.html
For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered warning: Unknown LDML tag: 'charsets/charset/collation/rules/aaa' If collation initialization is not possible, the server reports an ...In ... The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error ...
https://dev.mysql.com/doc/refman/5.7/en/compiler-characteristics.html
In some cases, the compiler used to build MySQL affects the features available for use. The notes in this section apply for binary distributions provided by Oracle Corporation or that you compile yourself from source. icc (Intel C++ Compiler) ...
https://dev.mysql.com/doc/refman/5.7/en/condition-handling-restrictions.html
For example, this statement is invalid: PREPARE stmt1 FROM 'SIGNAL SQLSTATE "02000"'; SQLSTATE values in class '04' are not treated specially. In standard SQL, the first condition relates to the SQLSTATE value returned for the previous SQL statement. SIGNAL, RESIGNAL, and GET DIAGNOSTICS are not permissible as prepared ...
https://dev.mysql.com/doc/refman/5.7/en/data-change-optimization.html
For inserting and updating large volumes of data (known in the industry as ETL, for “extract-transform-load”), sometimes you use other SQL statements or external commands, that mimic the effects of INSERT, UPDATE, and DELETE statements. This ...
https://dev.mysql.com/doc/refman/5.7/en/debugging-server.html
If mysqld does not want to start, verify that you have no my.cnf files that interfere with your setup! You can check your my.cnf arguments with mysqld --print-defaults and avoid using them by starting with mysqld --no-defaults .... It may be a good ... If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe ...
https://dev.mysql.com/doc/refman/5.7/en/drop-event.html
You can override this and cause the statement to generate a warning for nonexistent events instead using IF EXISTS. This statement requires the EVENT privilege for the schema to which the event to be dropped belongs. DROP EVENT [IF EXISTS] ...
https://dev.mysql.com/doc/refman/5.7/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-filtering.html
The log_error_verbosity system variable controls server verbosity for writing error, warning, and note messages to the error log. If the value is greater than 2, the server logs aborted connections and access-denied errors for new connection ...
https://dev.mysql.com/doc/refman/5.7/en/error-log-format.html
Timestamps are written using ISO 8601 / RFC 3339 format: YYYY-MM-DDThh:mm:ss.uuuuuu plus a tail value of Z signifying Zulu time (UTC) or ±hh:mm (an offset that indicates the local system time zone adjustment relative to UTC). The ID included in ...