PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
| +--------------------------------------------------------+ version_tokens_set(token_list) Replaces the server's list of version tokens with the tokens defined in the token_list argument and returns a binary string that indicates the outcome of the ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/5.7/en/view-algorithms.html
For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace corresponding parts of the statement. The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-crashing.html
If the Caps Lock light does not change, you have to replace your keyboard. This can normally be checked by pressing the Caps Lock key. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
(Alternatively, if you have the UPDATE privilege for the grant tables in the mysql system database, you can grant any account any privilege.) When the read_only system variable is enabled, GRANT additionally requires the SUPER privilege. Normally, a ...[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
The server's binary log consists of files containing “events” that describe modifications to database contents. --database=db_name, -d db_name Command-Line Format --database=db_name Type String This option causes mysqlbinlog to output entries ...To display their contents in text format, use the mysqlbinlog ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
These privileges are global because they are not specific to a particular database. Database privileges apply to a database and to all objects within it. These privileges can be granted for specific databases, or globally so that they apply to all ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. With --all-databases or --databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database. This ...