PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-reference.html
mysql> SELECT version_tokens_delete('tok1;tok3'); +------------------------------------+ | version_tokens_delete('tok1;tok3') | +------------------------------------+ | 2 version tokens deleted. (It is not an error to delete nonexisting tokens.) To ... 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/assignment-operators.html
Table 12.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/5.7/en/grant.html
For example: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'password'; GRANT ALL ON db1.* TO 'jeffrey'@'localhost'; GRANT SELECT ON db2.invoice TO 'jeffrey'@'localhost'; ALTER USER 'jeffrey'@'localhost' WITH MAX_QUERIES_PER_HOUR 90; Note Examples ...[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/mysql-cluster-options-variables.html
--ndb-optimized-node-selection Command-Line Format --ndb-optimized-node-selection System Variable ndb_optimized_node_selection Scope Global Dynamic Yes Type Integer Default Value 3 Minimum Value 0 Maximum Value 3 Enable optimizations for selection ... This section provides information about MySQL server options, server and status variables that are specific to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
A stored function invocation is logged as a SELECT statement if the function changes data and occurs within a statement that would not otherwise be logged. For example, SELECT statements are not written to the binary log, but a SELECT might invoke a ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Why does SELECT display them as “?” characters? This problem is usually due to a setting in MySQL that does not match the settings for the application program or the operating system. You can obtain this information for a column column_name in ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
mysql> SELECT COUNT(LRU_POSITION) FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE_LRU WHERE TABLE_NAME='`employees`.`employees`' AND LRU_POSITION < 3072; +---------------------+ | COUNT(LRU_POSITION) | +---------------------+ | 548 | ... The InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. InnoDB supports two types of locking reads that offer extra safety: SELECT ... Other transactions ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
The creating session can perform any operation on the table, such as DROP TABLE, INSERT, UPDATE, or SELECT. FILE Affects the following operations and server behaviors: Enables reading and writing files on the server host using the LOAD DATA and ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
Consider the following EXPLAIN statement, for a SELECT query that contains a derived table: EXPLAIN SELECT * FROM (SELECT * FROM t1) AS derived_t1; The optimizer avoids materializing the derived table by delaying it until the result is needed during ...The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more efficient execution ...