PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
After missing four heartbeat intervals in a row, the node is declared dead. If one node uses 5000 milliseconds and the node watching it uses 1000 milliseconds, obviously the node is declared dead very quickly. If a MySQL server fails to send a ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
Compound statements can contain declarations, loops, and other control structure statements. To declare that a function is deterministic, you must specify DETERMINISTIC explicitly. Assessment of the nature of a routine is based on the “honesty” ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling.html
Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing execution. Handlers can be defined for general conditions such as warnings or exceptions, or for specific ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) When you create a stored function, you must declare either that it is deterministic or that it does not modify data. MySQL does not check that a function declared ... The ...
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
In other cases, you must declare indexed columns as NOT NULL or an error results. If they are not explicitly declared as NOT NULL, MySQL declares them so implicitly (and silently). Spatial types are supported only for InnoDB and MyISAM tables, and ...| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
If a default value evaluates to a data type that differs from the declared column type, implicit coercion to the declared type occurs according to the usual MySQL type-conversion rules. If a default value evaluates to a data type that differs from ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-variables.html
In addition, stored programs can use DECLARE to define local variables, and stored routines (procedures and functions) can be declared to take parameters that communicate values between the routine and its caller. To declare local variables, use the ... System variables and user-defined variables can be used in stored programs, just as they can be used outside stored-program ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
One problem here is that MySQL can use indexes on columns more efficiently if they are declared as the same type and size. In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. tt.ActualPC is declared as ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL may change some or all information before passing it on. RESIGNAL is related to SIGNAL, but instead of originating a condition as SIGNAL does, RESIGNAL relays existing condition information, possibly after modifying it. RESIGNAL makes it ...