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/string-literals.html
This is true even for strings that are preceded by an introducer that indicates a different character set, as discussed in Section 12.3.6, “Character String Literal Character Set and Collation”. The \% and \_ sequences are used to search for ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
row *************************** QUERY: SELECT SUM(alias2.col_varchar_nokey) AS c1, alias2.pk AS c2 FROM t1 AS alias1 STRAIGHT_JOIN t2 AS alias2 ON alias2.pk = alias1.col_int_key WHERE alias1.pk GROUP BY c2 ORDER BY alias1.col_int_key, alias2.pk This ...Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. | ...The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
WITH followed by WITH at the same level is not permitted, so this is illegal: WITH cte1 AS (...) WITH cte2 AS (...) SELECT ... This is illegal: WITH cte1 AS (...), cte1 AS (...) SELECT ... This constraint rules out mutually-recursive CTEs, where ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-debian.html
Be aware that they may differ from those built by Oracle in features, capabilities, and conventions (including communication setup), and that the instructions in this manual do not necessarily apply to installing them. This is the preferred method ... Oracle provides Debian packages for installing MySQL on Debian or Debian-like Linux ...
https://dev.mysql.com/doc/refman/8.0/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. For example, to drop multiple columns in a single statement, do this: ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d; If a storage engine does ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/apis-php-info.html
The MySQL PHP API manual is now published in standalone form, not as part of the MySQL Reference Manual.
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
An implication of this change in behavior is that bit operations on binary string arguments might produce a different result in MySQL 8.0 than in 5.7. For information about how to prepare in MySQL 5.7 for potential incompatibilities between MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/charset-configuration.html
You can force client programs to use specific character set as follows: [client] default-character-set=charset_name This is normally unnecessary. However, when character_set_system differs from character_set_server or character_set_client, and you ... The MySQL server has a compiled-in default character set and ...