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/mysql-installer-workflow.html
If you attempt to install a product that is incompatible with the existing MySQL server version (or a version selected for upgrade), you are alerted about the possible mismatch. MySQL Installer provides the following sequence of actions that apply ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
mysql> SELECT 'a' = 'A'; -> 1 mysql> SELECT BINARY 'a' = 'A'; -> 0 mysql> SELECT 'a' = 'a '; -> 1 mysql> SELECT BINARY 'a' = 'a '; -> 0 In a comparison, BINARY affects the entire operation; it can be given before either operand with the same result.
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
mask_ssn() masks all but the last four digits of the number: mysql> SELECT mask_ssn(gen_rnd_ssn()); +-------------------------+ | mask_ssn(gen_rnd_ssn()) | +-------------------------+ | XXX-XX-1723 | +-------------------------+ Generating Random ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
The following example creates a simple rule to match statements that select a single literal value: INSERT INTO query_rewrite.rewrite_rules (pattern, replacement) VALUES('SELECT ?', 'SELECT ? + 1'); The resulting table contents look like this: ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
Consider the following subquery comparison: outer_expr IN (SELECT inner_expr FROM ... The converted comparison looks like this: EXISTS (SELECT 1 FROM ... If oe_i and ie_i represent corresponding outer and inner expression values, this subquery ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
mysql> SELECT -> UpdateXML('<a><b>ccc</b><d></d></a>', '/a', '<e>fff</e>') AS val1, -> UpdateXML('<a><b>ccc</b><d></d></a>', '/b', '<e>fff</e>') AS val2, -> UpdateXML('<a><b>ccc</b><d></d></a>', '//b', '<e>fff</e>') AS val3, -> ... Table 12.16 XML ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
For example: SELECT * FROM t1 WHERE t1.column1 IN (SELECT column1 FROM t2 ORDER BY column1); SELECT * FROM t1 WHERE t1.column1 IN (SELECT DISTINCT column1 FROM t2); SELECT * FROM t1 WHERE EXISTS (SELECT * FROM t2 LIMIT 1); Replace a join with a ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
In this query, the index on (key_part1, key_part2) enables the optimizer to avoid sorting: SELECT * FROM t1 ORDER BY key_part1, key_part2; However, the query uses SELECT *, which may select more columns than key_part1 and key_part2. If SELECT * ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
Example: mysql> SELECT mask_ssn('909-63-6922'), mask_ssn('abcdefghijk'); +-------------------------+-------------------------+ | mask_ssn('909-63-6922') | mask_ssn('abcdefghijk') | +-------------------------+-------------------------+ | XXX-XX-6922 ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
This section describes the MySQL Installer product catalog, the dashboard, and other actions related to product selection and upgrades. An up-to-date catalog performs the following actions: Populates the Available Products pane of the Select ...