PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
Triggers cannot use NEW.col_name or use OLD.col_name to refer to generated columns. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Basic column value checks occur prior to trigger ... CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value FIXED Valid Values FIXEDDYNAMIC In NDB ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
No InnoDB table definition may contain a foreign key reference to a user-partitioned table; no InnoDB table with user-defined partitioning may contain columns referenced by foreign keys. ORDER BY column statement run against a partitioned table ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. Truncation of excess trailing spaces from values to be inserted ...
https://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initializated and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...Any of the synonyms for CURRENT_TIMESTAMP have the same meaning as ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
If strict SQL mode is not enabled and you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. For VARCHAR columns, trailing spaces in excess of the column ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-files-table.html
The FILES table has these columns: FILE_ID For InnoDB: The tablespace ID, also referred to as the space_id or fil_space_t::id. For NDB: For a Disk Data undo log file, the auto-generated ID number of the log file group to which the log file belongs.
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-table-info.html
Auto increment key, Last value The key number associated the table's AUTO_INCREMENT column, and the most recently generated value for this column. “Record” and “row” are synonymous, as are “field” and “column.” The initial part of ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. innodb_log_checksum_algorithm: Specifies how to generate and verify checksum stored in each redo log disk ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
--complete-insert Command-Line Format --complete-insert Write complete INSERT statements that include column names. The output generated by using --events contains CREATE EVENT statements to create the events. --hex-blob Command-Line Format ...