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/entering-queries.html
(Do you see the error in the statement? The string 'Smith is missing the second single quotation mark.) At this point, what do you do? The simplest thing is to cancel the query. We'll get to others later.) When you issue a query, mysql sends it to ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/5.7/en/handler-scope.html
A specific handler is for a MySQL error code, SQLSTATE value, or condition name. For example, there might be a specific MySQL error code handler in an outer block, and a general SQLWARNING handler in an inner block. Or there might be handlers for a ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
(See Section 6.2.12, “Server Handling of Expired Passwords”.) --connect-timeout=value Command-Line Format --connect-timeout=value Type Numeric Default Value 0 The number of seconds before connection timeout. If the file does not exist or is ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. These differ only in the maximum length of the values they can hold. These correspond to the four BLOB types and have the same maximum lengths and storage ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...
https://dev.mysql.com/doc/refman/5.7/en/group-by-optimization.html
There are two ways to execute a GROUP BY query through index access, as detailed in the following sections. The second method first performs a range scan, and then groups the resulting tuples. The most general way to satisfy a GROUP BY clause is to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-event-buffer.html
BUFFERED_EPOCHS_OVER_THRESHOLD: Whether the number of buffered epochs has exceeded the configured threshold. The report is generated every second until the number of buffered epochs goes below the threshold, which can be adjusted by setting the ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
This section is for the cases where a table check fails (such as those described in Section 7.6.2, “How to Check MyISAM Tables for Errors”), or you want to use the extended features that myisamchk provides. Stage 1: Checking your tables Run ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html
If the new server is a replication source server and has old replicas that do not support multiple triggers, an error occurs on those replicas if a trigger is created on the source for a table that already has a trigger with the same trigger event ... With statement-based replication, triggers executed on the source also execute on the ...If under row-based replication the replica applied the triggers as well as the row changes caused by them, the changes would in ...
https://dev.mysql.com/doc/refman/5.7/en/stored-program-restrictions.html
In addition—due to rounding, the nature of threaded applications, and the fact that a nonzero length of time is required to create events and to signal their execution—events may be delayed by as much as 1 or 2 seconds. However, the time shown ...If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the ...