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/mysql-cluster-programs-ndb-restore.html
You should use this option prior to inserting new rows into the database; otherwise, it is possible for a row to be inserted that later causes a unique constraint violation when trying to rebuild the indexes. The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/create-table-secondary-indexes.html
Prior to 5.7.16, a foreign key constraint cannot reference a secondary index defined on a virtual generated column. In MySQL 5.7.13 and earlier, InnoDB does not permit defining a foreign key constraint with a cascading referential action on the base ...A secondary index defined on a virtual column is sometimes referred to as a “virtual ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-functions.html
MySQL Enterprise Encryption functions have these general characteristics: For arguments of the wrong type or an incorrect number of arguments, each function returns an error. If the arguments are not suitable to permit a function to perform the ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/gis-class-geometrycollection.html
There are no other constraints on the elements of a geometry collection, although the subclasses of GeometryCollection described in the following sections may restrict membership. Restrictions may be based on: Element type (for example, a MultiPoint ... A GeometryCollection is a geometry that is a collection of zero or more geometries of any ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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 ...