PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
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/create-table-foreign-keys.html
Hidden columns that InnoDB adds to an index are also considered in such cases (see Section 17.6.2.1, “Clustered and Secondary Indexes”). MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-information-schema.html
In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA table. When the underlying data dictionary tables store values ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
gen_blocklist(str, from_dictionary_name, to_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking, install it according to the instructions provided at Section 8.5.4.1, “MySQL Enterprise Data Masking Plugin Installation”. To use MySQL Enterprise Data Masking in applications, invoke the functions ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking.html
Example 2: A credit card processor company provides a set of services using sensitive data, such as: Processing a large number of financial transactions per second. Note MySQL Enterprise Data Masking is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/data-type-defaults.html
For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows are inserted. Data type specifications can have explicit or implicit default values. A DEFAULT value ...
https://dev.mysql.com/doc/refman/9.7/en/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...