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/replication-gtids-lifecycle.html
Because gtid_next is set to the GTID already assigned by the source, the replica does not attempt to generate a new GTID for this transaction, but instead uses the GTID stored in gtid_next. What changes are assigned a GTID? The typical scenario is ... The life cycle of a GTID consists of the following steps: A transaction is executed and committed on the replication source ...
https://dev.mysql.com/doc/refman/5.7/en/charset-conversion.html
To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful conversion to occur, one of the following conditions must apply: If the column has a binary data type (BINARY, VARBINARY, BLOB), all ...Suppose that the server's default character set was latin1 and col1 is defined as CHAR(50) but its contents are sjis ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA ...IS_GRANTABLE YES if the user has the GRANT OPTION privilege, NO ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references.
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. If no column is given, all matching columns and column types in the table are shown. The output displays only the names of those ...The same information can be obtained by using those statements ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
minimal: Log only those columns in the before image that are required to identify the row to be changed; log only those columns in the after image where a value was specified by the SQL statement, or generated by auto-increment. Set to NONE to ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
An alias can be used in a query select list to give a column a different name. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. In the select list of a query, a quoted column ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. This phenomenon can lead to different results for a given TIMESTAMP ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
MySQL also permits a “relaxed” string format when updating and in a WHERE clause that compares a date to a DATE, DATETIME, or TIMESTAMP column. However, this conversion is subject to the following exceptions: When you compare two columns When ...