PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html
Choosing a Setup Type During the initial setup, you are prompted to select the MySQL products to be installed on the host. Select the Only install GA products option to restrict the product set to include GA products only when using these setup ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-range-list.html
You can see that this is the case by re-running the previous SELECT query: mysql> SELECT * FROM tr WHERE purchased -> BETWEEN '1995-01-01' AND '1999-12-31'; Empty set (0.00 sec) Note DROP PARTITION is supported by native partitioning in-place APIs ... Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
This means that a query such as SELECT * FROM partitioned_table WHERE date_column < '2008-12-00' does not return any values (see Bug #40972). For example, this statement cannot use pruning because dob is a DATE column: SELECT * FROM t4 WHERE dob >= ... The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be no matching ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-tables.html
SQL statements are expressed as text, such as DELETE FROM t1 or SELECT * FROM t2. Instruments for SQL statements have names that begin with statement/sql, such as statement/sql/delete and statement/sql/select. For example, SELECT * FROM is ...
https://dev.mysql.com/doc/refman/8.0/en/query-attributes.html
The first SELECT shows how to retrieve those attributes, and also demonstrates that retrieving a nonexistent attribute (n3) returns NULL. The second SELECT shows that attributes do not persist across statements. The SELECT shows that retrieving a ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
SELECT statement is logged as one transaction in the binary log when row-based replication is in use. SELECT statements are now safe for row-based replication and permitted for use with GTID-based replication. SELECT is applied as an atomic ...An ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collate.html
With the COLLATE clause, you can override whatever the default collation is for a comparison.
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-implementations.html
mysql> SET NAMES 'utf8mb4' COLLATE 'utf8mb4_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> SELECT HEX('a'), HEX(WEIGHT_STRING('a')); +----------+-------------------------+ | HEX('a') | HEX(WEIGHT_STRING('a')) | ... MySQL implements several ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-information-schema.html
For example, comparisons with SCHEMATA.SCHEMA_NAME match 'information_schema' or 'INFORMATION_SCHEMA' regardless of platform: mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'information_schema'; +--------------------+ ... String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is ...
https://dev.mysql.com/doc/refman/8.0/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...