PDF (US Ltr)
- 41.9Mb
PDF (A4)
- 42.0Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
This operator performs an equality comparison like the = operator, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL. Table 14.4 Comparison Operators Name Description > Greater than operator >= ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-installation.html
Note It is possible to install one plugin without the other, but both must be installed for full connection control capability. The connection_control_min_connection_delay and connection_control_max_connection_delay system variables both have ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
It specifies that the event executes one time only at the date and time given by timestamp, which must include both the date and time, or must be an expression that resolves to a datetime value. You may use STARTS, ENDS, both, or neither in an EVERY ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/9.7/en/datetime.html
The DATETIME type is used for values that contain both date and time parts. The TIMESTAMP data type is used for values that contain both date and time parts. This occurs because the same time zone was not used for conversion in both directions. This ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-triggers.html
Can triggers access tables? A trigger can access both old and new data in its own table. This is because, if both the source and the replica applied the changes from the source and, in addition, the trigger causing these changes were applied on the ...Where can I find the documentation for MySQL 9.7 triggers? ...
https://dev.mysql.com/doc/refman/9.7/en/function-resolution.html
In either case, once both functions exist, it is necessary thereafter to qualify the stored function with a schema name when invoking it; the server assumes in such cases that the unqualified name refers to the loadable function. MySQL supports ...
https://dev.mysql.com/doc/refman/9.7/en/get-diagnostics.html
GET DIAGNOSTICS can obtain either statement or condition information, but not both in the same statement: To obtain statement information, retrieve the desired statement items into target variables. Initially, both diagnostics areas return the same ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...
https://dev.mysql.com/doc/refman/9.7/en/gis-data-formats.html
For example, the following statements both use ST_X() to extract the X-coordinate from a Point object. Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format ...
https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html
The password_history table accumulates a sufficient number of nonempty passwords per account to enable MySQL to perform checks against both the account password history length and reuse interval. Automatic pruning of entries that are outside both ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-configuring-consistency-guarantees.html
The BEFORE and BEFORE_AND_AFTER consistency levels can be used on both read-only and read/write transactions. How to Choose a Consistency Level The different consistency levels provide flexibility to both DBAs, who can use them to set up their ...