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/handler.html
This table object is not shared by other sessions and is not closed until the session calls HANDLER ... This statement works for InnoDB tables as well, but there is no such concept because there is no separate data file. This occurs when both of the ... 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/identifier-qualifiers.html
For example, this statement creates a table using the unqualified name t1: CREATE TABLE t1 (i INT); Because t1 includes no qualifier to specify a database, the statement creates the table in the default database. This statement creates a table using ...An unqualified name is permitted in contexts where interpretation of the name is ...
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. (This does not apply to other operations on temporary tables ...Most of these statements also cause an implicit commit after ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-cols-table.html
The INNODB_SYS_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field, using the same value as INNODB_SYS_FOREIGN.ID. POS The ordinal position of this key field within the foreign key index, starting from ... The INNODB_SYS_FOREIGN_COLS table provides status information about the columns of InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN_COLS table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-foreign-table.html
FOR_NAME The name of the child table in this foreign key relationship. REF_NAME The name of the parent table in this foreign key relationship. row *************************** ID: test/fk1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 ... The INNODB_SYS_FOREIGN table provides metadata about InnoDB foreign keys, equivalent to the information from the SYS_FOREIGN table in the InnoDB data ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
If the constraint is a foreign key, then this is the column of the foreign key, not the column that the foreign key references. For foreign-key constraints, this column is the ordinal position in key of the table that is being referenced. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-referential-constraints-table.html
The REFERENTIAL_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. UNIQUE_CONSTRAINT_CATALOG The name ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-statistics-table.html
This can have values A (ascending), D (descending), or NULL (not sorted). To update this number, run ANALYZE TABLE or (for MyISAM tables) myisamchk -a. Take this into account when specifying a prefix length for a nonbinary string column that uses a ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
This section builds on the conceptual information about deadlocks in Section 14.7.5.2, “Deadlock Detection”. For example, if you need to write to table t1 and read from table t2, you can do this: SET autocommit=0; LOCK TABLES t1 WRITE, t2 READ, ...It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in ...