PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/faqs-virtualization.html
Is MySQL supported on virtualized environments such as Oracle VM, VMWare, Docker, Microsoft Hyper-V, or others? MySQL is supported on virtualized environments, but is certified only for Oracle VM. The usual ones are related to performance, ...Is ...
https://dev.mysql.com/doc/refman/5.7/en/gpg-key-archived-packages.html
For signature checking instructions, see Section 2.1.4.2, “Signature Checking Using GnuPG”. The following GPG public build key (keyID 5072E1F5) can be used to verify the authenticity and integrity of MySQL 5.7.36 packages and earlier.