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/data-dictionary-schema.html
Data dictionary tables are protected and may only be accessed in debug builds of MySQL. However, MySQL supports access to data stored in data dictionary tables through INFORMATION_SCHEMA tables and SHOW statements. For an overview of the tables ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-component-functions.html
mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' characters. Nine digits grouped in pattern: xxx-xxx-xxx ('-' is any separator character). Return value: ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-components-vs-plugin.html
Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative implementation. The following table briefly compares MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-policy-usage.html
Dynamic data masking enables you to conditionally mask column data for specific users or roles. A masking policy is a rule, or set of rules, which determines how a column's data is transformed for access control. A masking policy consists of the ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking.html
Note MySQL Enterprise Data Masking is an extension included in MySQL Enterprise Edition, a commercial product. Note This feature was known previously as “MySQL Enterprise Data Masking and De-Identification”. MySQL Enterprise Data Masking ...
https://dev.mysql.com/doc/refman/9.7/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/9.7/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/9.7/en/ddl-rewriter-options.html
This section describes the command options that control operation of the ddl_rewriter plugin. If values specified at startup time are incorrect, the ddl_rewriter plugin may fail to initialize properly and the server does not load it. To control ...
https://dev.mysql.com/doc/refman/9.7/en/debugging-server.html
If you are using some functionality that is very new in MySQL, you can try to run mysqld with the --skip-new option (which disables all new, potentially unsafe functionality). If mysqld does not want to start, verify that you have no my.cnf files ...
https://dev.mysql.com/doc/refman/9.7/en/delete-optimization.html
The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. To delete all ...