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/identifier-qualifiers.html
ON mydb.mytable ...; A column name may be given multiple qualifiers to indicate context in statements that reference it, as shown in the following table. Suppose that column c1 occurs only in table t1, c2 only in t2, and c in both t1 and t2. Suppose ...An unqualified name is permitted in contexts where interpretation of the name is ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
“Identical” means that all tables have identical column data types and index information. You cannot merge MyISAM tables in which the columns are listed in a different order, do not have exactly the same data types in corresponding columns, or ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-hash.html
This can simply be the name of a column whose type is one of MySQL's integer types. You should be aware that, if a table has any unique keys, every column used in the partitioning expression for this table must be part of every unique key, including ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
The replication_applier_status_by_worker table has these columns: CHANNEL_NAME The replication channel which this row is displaying. WORKER_ID The worker identifier (same value as the id column in the mysql.slave_worker_info table). After STOP ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-summary-tables.html
row *************************** EVENT_NAME: transaction COUNT_STAR: 5 SUM_TIMER_WAIT: 19550092000 MIN_TIMER_WAIT: 2954148000 AVG_TIMER_WAIT: 3910018000 MAX_TIMER_WAIT: 5486275000 COUNT_READ_WRITE: 5 SUM_TIMER_READ_WRITE: 19550092000 ... The ...
https://dev.mysql.com/doc/refman/5.7/en/charset-examples.html
Example 1: Table and Column Definition CREATE TABLE t1 ( c1 CHAR(10) CHARACTER SET latin1 COLLATE latin1_german1_ci ) DEFAULT CHARACTER SET latin2 COLLATE latin2_bin; Here we have a column with a latin1 character set and a latin1_german1_ci ... The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
Evaluation of statements that contain an ORDER BY clause and a different GROUP BY clause, or for which the ORDER BY or GROUP BY contains columns from tables other than the first table in the join queue. To determine whether a statement requires a ...
https://dev.mysql.com/doc/refman/5.7/en/show-events.html
SHOW EVENTS output has these columns: Db The name of the schema (database) to which the event belongs. The value shown in this column reflects the addition or subtraction of any INTERVAL value included in the event's AT clause. For example, if an ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-files.html
n_length is the total length of all column names, including one byte per name as a separator. int_length is related to the list of values for ENUM and SET columns. In this context, “int” does not mean “integer.” It means “interval,” a ...