PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...
https://dev.mysql.com/doc/refman/8.0/en/compatibility.html
MySQL Server was originally designed to work with medium-sized databases (10-100 million rows, or about 100MB per table) on small computer systems. This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
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 Shell. For information on establishing connections using command-line options, for ...For additional information if you are unable to connect, see Section 8.2.22, “Troubleshooting Problems Connecting to ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.0/en/custom-benchmarks.html
Even if the overall performance for your application currently is acceptable, you should at least make a plan for each bottleneck and decide how to solve it if someday you really need the extra performance. In most cases, performance problems turn ... Benchmark your application and database to find out where the bottlenecks ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components.html
MySQL Enterprise Data Masking and De-Identification implements these elements: A table in the mysql system database for persistent storage of dictionaries and terms. A component named component_masking that implements masking functionality and ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
In MySQL 8.0.19 and later, you can specify a time zone offset when inserting a TIMESTAMP or DATETIME value into a table. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter-installation.html
To install the ddl_rewriter plugin, use the INSTALL PLUGIN statement, adjusting the .so suffix for your platform as necessary: INSTALL PLUGIN ddl_rewriter SONAME 'ddl_rewriter.so'; To verify plugin installation, examine the Information Schema ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
For information available through SHOW statements, it is possible in many cases to obtain equivalent information by using a cursor with an INFORMATION_SCHEMA table. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor ...