PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/union.html
FROM t2) ORDER BY sort_col; To additionally maintain sort order within individual SELECT results, add a secondary column to the ORDER BY clause: (SELECT 1 AS sort_col, col1a, col1b, ... UNION queries with an aggregate function in an ORDER BY clause ...[UNION [ALL | DISTINCT] SELECT ...] UNION combines the result from multiple SELECT statements into a single result ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. Command-Line Format -mbyte # Type Numeric Default Value 0 Minimum Value 0 Maximum Value 15 -mbyte #: Starting megabyte. Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that violates this limitation fails with NDB error 851 Maximum offset for fixed-size columns exceeded. When using the NDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
DATETIME is packed more efficiently, requiring 5 rather than 8 bytes for the nonfractional part, and all three parts have a fractional part that requires from 0 to 3 bytes, depending on the fractional seconds precision of stored values. Fractional ... InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage requirements for table data on disk depend on several ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
If a TIMESTAMP or DATETIME column definition includes an explicit fractional seconds precision value anywhere, the same value must be used throughout the column definition. TIMESTAMP and DATETIME columns can be automatically initializated and ...An ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. Trace files are generated by critical errors in ndbmtd processes in a ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
The maximum number of condition areas in a diagnostics area is determined by the value of the max_error_count system variable. ERROR 1051 (42S02): Unknown table 'xx' Then execution enters the EXIT handler. ERROR 1051 (42S02): Unknown table 'xx' At ...RESIGNAL makes it possible to both handle an error and return the error ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. (OpenSSL imposes its own key-length limits, and server administrators can ...If the arguments are not suitable to permit a function to perform the requested operation, it returns NULL or 0 as ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...If the index is a covering index (one that includes all the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
InnoDB supports a maximum of 128 rollback segments, 32 of which are allocated to the temporary tablespace. Note It is possible to encounter a concurrent transaction limit error before reaching the number of concurrent read-write transactions that ...