PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
Support for foreign key constraints in NDB 9.7 is comparable to that provided by InnoDB, subject to the following restrictions: Every column referenced as a foreign key requires an explicit unique key, if it is not the table's primary key. A partial ... Some SQL statements relating to certain MySQL features produce errors when used with NDB tables, as described in the following list: Temporary ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-exchange.html
To see how this occurs, first insert a row into e2 that is outside the boundaries of the partition definition for partition p0 of table e. Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. There ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
The data types are listed here: Integer: All variants and aliases of MySQL integer data types are supported, including TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT. BOOL and SERIAL are also supported, and treated as integer types. Floating point: ... Most MySQL data types are supported for MLE stored program input and output arguments, as well as for return data ...
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
Block Nested-Loop Flags block_nested_loop (default on) Controls use of hash joins, as do the BNL and NO_BNL optimizer hints. For more information, see Section 10.2.2.5, “Derived Condition Pushdown Optimization” Derived Table Merging Flags ...Its ...
https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html
The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each row inserted into the table. In the example, the trigger body is a simple SET that accumulates into ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.26, “CREATE TRIGGER Statement”, and Section 15.1.39, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). FILE_BLOCK_SIZE is required when you intend to use the tablespace for storing compressed InnoDB ...
https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/9.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. This following example relates parent and child tables through a single-column foreign ...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/9.7/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. To import the dump file into a new database, and have the tables ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-system-tables.html
The InnoDB INFORMATION_SCHEMA table interface allows you to query this data using SQL. As a final step, insert a row into table t1 (TABLE_ID = 71) and view the data in the INNODB_TABLESTATS table. mysql> INSERT INTO t1 VALUES(5, 'abc', 'def'); Query ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA ...