PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
MySQL Server supports some extensions that are likely not to be found in other SQL DBMSs. Be warned that if you use them, your code is not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
Is it possible to group stored procedures or stored functions into packages? A.4.9. Is it possible to group stored procedures or stored functions into packages? No. Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-views.html
Can you insert into views that are based on joins? A.6.1. Can you insert into views that are based on joins? It is possible, provided that your INSERT statement has a column list that makes it clear there is only one table involved. You cannot ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-reference.html
Switching the mode from OFF to RECORDING reloads the allowlist from the mysql.firewall_whitelist table into the cache. Example: SELECT mysql_firewall_flush_status(); normalize_statement(stmt) This function normalizes an SQL statement into the digest ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
FLUSH TABLES WITH READ LOCK does not prevent the server from inserting rows into the log tables (see Section 5.4.1, “Selecting General Query Log and Slow Query Log Output Destinations”). The .cfg file contains metadata needed to reimport the ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
A value of 6 is considered drastic because database pages are left in an obsolete state, which in turn may introduce more corruption into B-trees and other database structures. Leaves database pages in an obsolete state, which in turn may introduce ... To investigate database page corruption, you might dump your tables from the database with SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/fractional-seconds.html
(This differs from the standard SQL default of 6, for compatibility with previous MySQL versions.) Inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column of the same type but having fewer fractional digits results in ... MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that includes a fractional seconds part, use the syntax type_name(fsp), where type_name is TIME, DATETIME, or TIMESTAMP, and fsp is the fractional seconds ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
The full-text engine splits the phrase into words and performs a search in the FULLTEXT index for the words. If you create a MyISAM table and insert only one or two rows of text into it, every word in the text occurs in at least 50% of the rows. By ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
Issuing multiple GRANT statements containing wildcards may not have the expected effect on DML statements; when resolving grants involving wildcards, MySQL takes only the first matching grant into consideration. [REQUIRE {NONE | tls_option [[AND] ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-limitations.html
Group Replication's certification process for concurrent transactions does not take into account gap locks, as information about gap locks is not available outside of InnoDB. The certification process does not take into account table locks (see ...