Search

Download this Manual
PDF (US Ltr) - 35.0Mb
PDF (A4) - 35.1Mb
Man Pages (TGZ) - 255.4Kb
Man Pages (Zip) - 360.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb


Displaying 41 to 50 of 992 total results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-columns-table.html
The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. The INNODB_SYS_COLUMNS table provides metadata about InnoDB table columns, equivalent to the information from the SYS_COLUMNS table ...For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA System ...
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/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/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/create-table-foreign-keys.html
Prior to 5.7.16, a foreign key constraint cannot reference a secondary index defined on a virtual generated column. A foreign key constraint on a stored generated column cannot use CASCADE, SET NULL, or SET DEFAULT as ON UPDATE referential actions, ...A foreign key relationship involves a parent table that holds the initial column values, and a child table with column values that reference the parent column ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
If strict SQL mode is enabled, an INSERT statement generates an error if it does not specify an explicit value for every column that has no default value. If a generated column is inserted into explicitly, the only permitted value is DEFAULT. For ...
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/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
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.
Displaying 41 to 50 of 992 total results