PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
CHECK constraints cannot refer to columns that have the AUTO_INCREMENT attribute, nor can the AUTO_INCREMENT attribute be added to existing columns that are used in CHECK constraints. MySQL supports an extension for optionally specifying the ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
On storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... An atomic DDL statement combines the data dictionary updates, storage engine operations, and binary log writes ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
If you have UNIQUE constraints on secondary keys, you can speed up a table import by turning off the uniqueness checks temporarily during the import operation: SET unique_checks=0; ... You can designate the former primary key columns as UNIQUE NOT ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
LIKE, the destination table preserves CHECK constraints from the original table, except that all the constraint names are generated. LIKE to create an empty table based on the definition of another table, including any column attributes and indexes ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
As of MySQL 8.0.21, on storage engines that support both atomic DDL and foreign key constraints, creation of foreign keys is not permitted in CREATE TABLE ... You can create one table from another by adding a SELECT statement at the end of the ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-functions-legacy.html
In releases before MySQL 8.0.30, MySQL Enterprise Encryption's functions are based on the openssl_udf shared library. The functions continue to be available in later releases if they have been installed, but they are deprecated. For information on ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Because a replica has authority to execute any statement read from a source's binary log, special security constraints exist for using stored functions with replication. It records only DML events and does not factor in timing constraints. Where can ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometrycollection.html
There are no other constraints on the elements of a geometry collection, although the subclasses of GeomCollection described in the following sections may restrict membership. Restrictions may be based on: Element type (for example, a MultiPoint may ... A GeomCollection is a geometry that is a collection of zero or more geometries of any ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
row *************************** ID: test/fk1 FOR_NAME: test/child REF_NAME: test/parent N_COLS: 1 TYPE: 1 Metadata includes the foreign key ID (fk1), which is named for the CONSTRAINT that was defined on the child table. You can extract metadata ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...