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/debugging-server.html
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 functionality). If mysqld does not want to start, verify that you have no my.cnf files ...
https://dev.mysql.com/doc/refman/5.7/en/delete.html
To check the number of deleted rows, call the ROW_COUNT() function described in Section 12.15, “Information Functions”. DELETE is a DML statement that removes rows from a table. Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM ...
https://dev.mysql.com/doc/refman/5.7/en/differences-from-ansi.html
The CAST() function does not support cast to REAL or BIGINT. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used ...
https://dev.mysql.com/doc/refman/5.7/en/document-store.html
The Section 19.2, “Setting Up MySQL as a Document Store” section explains how to configure X Plugin on a MySQL Server, so it can function as a document store, and how to install MySQL Shell to use as a client. The following MySQL products ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
For example, a value of 3 includes all of the functionality of values 1 and 2. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
After create This occurs when the thread creates a table (including internal temporary tables), at the end of the function that creates the table. The following list describes thread State values that are associated with general query processing ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html
In MySQL 8.0, you can use the GROUPING() function to test the distinction. The GROUP BY clause permits a WITH ROLLUP modifier that causes summary output to include extra rows that represent higher-level (that is, super-aggregate) summary operations. ROLLUP thus enables you to answer questions at multiple levels of analysis with a single ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
Moreover, InnoDB provides some additional functionality that enables better management and handling of conflicts when operating together with Group Replication. Server instances that you want to use for Group Replication must satisfy the following ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name includes at least one qualifier to clarify the interpretive context by overriding a default context or providing missing context. For ...