Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/mysql-nutshell.html
This is true for sorts performed entirely in memory as well as for sorts that require writing to and reading from disk. JSON_SCHEMA_VALID() returns TRUE (1) if the document validates against the schema and FALSE (0) if it does not. If they contain ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/osx-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/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/c-api-data-structures.html
my_bool A boolean type, for values that are true (nonzero) or false (zero). Pass the type value to IS_NUM() and it evaluates to TRUE if the field is numeric: if (IS_NUM(field->type)) printf("Field is numeric\n"); ENUM and SET values are returned as ... This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
https://dev.mysql.com/connecting-using-uri-or-key-value-pairs.html
For example: mysql://user@localhost:3306?get-server-public-key=true This option applies to clients that authenticate with the caching_sha2_password authentication plugin. compression: When set to true (or 1), this option enables compression of all ... This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL ...
https://dev.mysql.com/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/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/mysql-cluster-programs-ndb-perror.html
--ndb Property Value Command-Line Format --ndb Type Boolean Default Value TRUE For compatibility with applications depending on old versions of perror that use that program's --ndb option. --silent, -s Property Value Command-Line Format --silent ...
https://dev.mysql.com/replication-gtids-functions.html
These functions are as follows: GTID_SUBSET(set1,set2) Given two sets of global transaction identifiers set1 and set2, returns true if all GTIDs in set1 are also in set2. This function returns nonzero (true) if two GTID sets are the same set, even ... MySQL includes some built-in (native) functions for use with GTID-based ...
https://dev.mysql.com/replication-options-gtids.html
When binlog_gtid_simple_recovery=TRUE, which is the default in MySQL 8.0, the values of gtid_executed and gtid_purged are computed at startup based on the values of Previous_gtids_log_event in the most recent and oldest binary log files. If all ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-true-p-3.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
