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/create-table.html
The maximum MAX_ROWS value is 4294967295; larger values are truncated to this limit. | {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] ...
https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html
Similar to the system tablespace, truncating or dropping tables stored in a general tablespace creates free space internally in the general tablespace .ibd data file which can only be used for new InnoDB data. The precise syntax and semantics depend ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
DROP TABLE and TRUNCATE TABLE statements on the table do not activate this trigger, because they do not use DELETE. CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The ...
https://dev.mysql.com/doc/refman/5.7/en/fixed-point-types.html
(The precise behavior is operating system-specific, but generally the effect is truncation to the permissible number of digits.) . The DECIMAL and NUMERIC types store exact numeric data values. These types are used when it is important to preserve ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Note The statement TRUNCATE TABLE performance_schema.host_cache, unlike FLUSH HOSTS, is not written to the binary log. | table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ... FOR EXPORT } table_synonym: { TABLE | TABLES } The FLUSH ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
TRUNCATE TABLE for a table closes all handlers for the table that were opened with HANDLER OPEN. HANDLER tbl_name OPEN [ [AS] alias] HANDLER tbl_name READ index_name { = | <= | >= | < | > } (value1,value2,...) [ WHERE where_condition ] [LIMIT ... ] ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the statement. Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-indexes-table.html
The INNODB_SYS_INDEXES table provides metadata about InnoDB indexes, equivalent to the information in the internal SYS_INDEXES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tables-table.html
The INNODB_SYS_TABLES table provides metadata about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary. For related usage information and examples, see Section 14.16.3, “InnoDB INFORMATION_SCHEMA ...