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/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash value, and uses them to update the normalized_pattern and pattern_digest columns: mysql> SELECT * FROM ... To ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. The ENUM type has these advantages: Compact data storage in situations where a column ...See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-schema.html
0 in the epoch column of this table indicates a transaction originating from a storage engine other than NDB. When mysqld is started with the --ndb-log-orig option, the orig_server_id and orig_epoch columns store, respectively, the ID of the server ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. In any query that performs arithmetic using column values, use the CAST() function to ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the view. The CREATE VIEW statement requires the ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
Memory required for indexes on NDB table columns is now allocated dynamically from that allocated for DataMemory. Other related changes are listed here: IndexMemory is no longer one of the values displayed in the ndbinfo.memoryusage table's ... New ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. (This applies to statements terminated by ; or \G.) --batch, -B Command-Line Format --batch Print results using tab as the column separator, with each row on a ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/5.7/en/order-by-optimization.html
The index may also be used even if the ORDER BY does not match the index exactly, as long as all unused portions of the index and all extra ORDER BY columns are constants in the WHERE clause. If the index does not contain all columns accessed by the ... This section describes when MySQL can use an index to satisfy an ORDER BY clause, the filesort operation used when an index cannot be used, and execution plan information available from the optimizer about ORDER ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-statement-summary-tables.html
Each statement summary table has one or more grouping columns to indicate how the table aggregates events. Event names refer to names of event instruments in the setup_instruments table: events_statements_summary_by_account_by_event_name has ... The ...