PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/logical-operators.html
Table 14.5 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value OR, || Logical OR XOR Logical XOR In SQL, all logical operators evaluate to TRUE, FALSE, or NULL (UNKNOWN). In MySQL, these are implemented as 1 (TRUE), 0 ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-mysql-option-table.html
To be shown in this table, a component or plugin must be written and compiled with support for the Option Tracker component. Not all MySQL components and plugins currently available provide such support. See Section 7.5.9.2, “Option Tracker ...
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/9.7/en/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document validates against the schema, and false if it does not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. Provided that these conditions are met: If the document ...
https://dev.mysql.com/doc/refman/9.7/en/macos-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/doc/refman/9.7/en/spatial-relation-functions-mbr.html
The return values 1 and 0 indicate true and false, respectively. In this case, ST_Contains(g1, g2) and MBRContains(g1, g2) both return true, as does ST_Within(g2, g1). In this case, MBRCovers(g1, g2) and MBRCoveredBy(g2, g1) both return true. (That ... MySQL provides several MySQL-specific functions that test the relationship between minimum bounding rectangles (MBRs) of two geometries g1 and ...
https://dev.mysql.com/doc/refman/9.7/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
select_type Value JSON Name Meaning SIMPLE None Simple SELECT (not using UNION or subqueries) PRIMARY None Outermost SELECT UNION None Second or later SELECT statement in a UNION DEPENDENT UNION dependent (true) Second or later SELECT statement in a ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- prefix. Boolean variables can be set at startup to the values ON, TRUE, OFF, and ...For example, to enable or disable the InnoDB adaptive hash index, you can use --innodb-adaptive-hash-index or --skip-innodb-adaptive-hash-index on the command line, or innodb_adaptive_hash_index or skip_innodb_adaptive_hash_index in an option ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
--ndb-log-transaction-dependency Command-Line Format --ndb-log-transaction-dependency={true|false} System Variable ndb_log_transaction_dependency Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value false Causes the NDB binary ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...