Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
When a dictionary of terms is created, it becomes part of the dictionary registry and is assigned a name to be used by other dictionary functions. All of the terms in a dictionary are accessible to any user account if that user executes ...
https://dev.mysql.com/doc/refman/9.7/en/explain-extended.html
For results consisting of multiple values, a temporary table may be created and <temporary table> is shown instead. <in_optimizer>(query fragment) This is an internal optimizer object with no user significance. <ref_null_helper>(expr) This is an ...
https://dev.mysql.com/doc/refman/9.7/en/fulltext-fine-tuning.html
Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. For an example specific to full-text indexing, see Section 14.9.7, “Adding a User-Defined Collation for Full-Text ...You can ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-introduction.html
Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key Advantages of InnoDB Its DML operations follow the ACID model, with transactions featuring commit, ... InnoDB is a general-purpose storage engine that balances high reliability and high ...
https://dev.mysql.com/doc/refman/9.7/en/ipv6-remote-connections.html
mysql> SELECT CURRENT_USER(), @@bind_address; +-----------------------------------+----------------+ | CURRENT_USER() | @@bind_address | +-----------------------------------+----------------+ | remoteipv6user@2001:db8:0:f101::2 | :: | ... The ...
https://dev.mysql.com/doc/refman/9.7/en/ipv6-support.html
IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable ...
https://dev.mysql.com/doc/refman/9.7/en/json-validation-functions.html
In this example, we set a user variable @schema to the value of a JSON schema for geographical coordinates, and another one @document to the value of a JSON document containing one such coordinate. In this example, we set a user variable @schema to ... MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the JSON Schema ...
https://dev.mysql.com/doc/refman/9.7/en/ldml-collation-example.html
The collation is designed for a scenario involving a Web application for which users post their names and phone numbers. You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-mysqld.html
row *************************** Id: 1 User: system user Host: db: Command: Daemon Time: 1 State: Waiting for event from ndbcluster Info: NULL Important To participate in an NDB Cluster, the mysqld process must be started with both the options ...To ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-gtids.html
Only statements that can be logged using GTID safe statements can be logged when enforce_gtid_consistency is set to ON, so the operations listed here cannot be used with this option: CREATE TEMPORARY TABLE or DROP TEMPORARY TABLE statements inside ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...