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/storage-requirements.html
Despite differences in storage layout on disk, the internal MySQL APIs that communicate and exchange information about table rows use a consistent data structure that applies across all storage engines. This section includes guidelines and ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-defining.html
This enables the ; delimiter used in the procedure body to be passed through to the server rather than being interpreted by mysql itself. Each stored program contains a body that consists of an SQL statement. This statement may be a compound ...
https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html
Parameters in_max_runtime INT UNSIGNED: The maximum data collection time in seconds. in_interval INT UNSIGNED: The sleep time between data collections in seconds. Creates a report of the current server status for diagnostic purposes. This procedure ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
This constraint rules out mutually-recursive CTEs, where cte1 references cte2 and cte2 references cte1. These constraints do not apply to the nonrecursive SELECT part of a recursive CTE. These constraints come from the SQL standard, other than the ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
They are often used with a GROUP BY clause to group values into subsets. The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). Prior ... This section describes aggregate functions that operate on sets of ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
Encryption Option The ENCRYPTION option, introduced in MySQL 8.0.16, defines the default database encryption, which is inherited by tables created in the database. Read Only Option The READ ONLY option, introduced in MySQL 8.0.22, controls whether ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary. Numeric evaluation occurs otherwise, with ... Table 14.17 Bit Functions and Operators Name Description & Bitwise AND >> Right shift << Left shift ^ Bitwise XOR BIT_COUNT() Return the number of bits that are set | Bitwise OR ~ Bitwise inversion The following list describes available bit functions and operators: | Bitwise ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/8.0/en/cache-index.html
After the indexes have been assigned, they can be preloaded into the cache if desired with LOAD INDEX INTO CACHE. For more information, see Section 15.7.8.5, “LOAD INDEX INTO CACHE Statement”. | tbl_name PARTITION (partition_list) } IN ...