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/out-of-memory.html
This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server). Is it reasonable that it should return so many rows? If not, correct the query and try again.
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid values. These features have several implications for numeric operations and provide a high degree of ...Precision math is based on these two features: SQL modes that control how strict the server is about accepting or rejecting invalid ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variable-reference.html
Please see the corresponding item descriptions for details on setting and using the variables. The last column indicates whether the scope for each variable is Global, Session, or both. Where appropriate, direct links to further information about ...
https://dev.mysql.com/doc/refman/5.7/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/5.7/en/start-group-replication.html
If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the ...
https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html
As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while Group Replication stops. To be completely safe, ensure that your applications can no longer connect to ...Any other replication channels running on the member are also ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-errors.html
Incorrect number of rows from subquery: ERROR 1242 (ER_SUBSELECT_NO_1_ROW) SQLSTATE = 21000 Message = "Subquery returns more than 1 row" This error occurs for statements where the subquery must return at most one row but returns multiple rows.
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
For example, this limitation applies to statements of the following forms: DELETE FROM t WHERE ... FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Prior to MySQL 5.7.14, backslashes in Windows path names are converted to forward slashes in the result. Example mysql> SELECT sys.format_path('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------+ | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-truncate-all-tables.html
Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Example mysql> CALL ...