PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...(Some valid select or union statement) CREATE TABLE creates a table with the given ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
Note If you use ALTER TABLE on a locked table, it may become unlocked. For example, if you attempt a second ALTER TABLE operation, the result may be an error Table 'tbl_name' was not locked with LOCK TABLES. To handle this, lock the table again ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
innodb_api_enable_mdl Command-Line Format --innodb-api-enable-mdl[={OFF|ON}] System Variable innodb_api_enable_mdl Scope Global Dynamic No Type Boolean Default Value OFF Locks the table used by the InnoDB memcached plugin, so that it cannot be ...In ... System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-operations.html
A newly created secondary index contains only the committed data in the table at the time the CREATE INDEX or ALTER TABLE statement finishes executing. Dropping an index DROP INDEX name ON table; ALTER TABLE tbl_name DROP INDEX name; The table ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
This may be desirable when backing up and restoring between different schema versions with primary key changes on one or more tables, and it appears that performing the restore operation using ndb_restore is simpler or mor efficient than issuing ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-table-import.html
Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... (Before importing, you must discard the tablespace of the receiving table.) mysql> ALTER TABLE t1 DISCARD TABLESPACE; On the source ... This ...As a faster way of moving data than importing a dump file, which requires reinserting data and rebuilding ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html
--disable-keys, -K Command-Line Format --disable-keys For each table, surround the INSERT statements with /*!40000 ALTER TABLE tbl_name DISABLE KEYS */; and /*!40000 ALTER TABLE tbl_name ENABLE KEYS */; statements. While a --single-transaction dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... You should also be aware of the following effects of ALTER TABLE ... The IGNORE keyword ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ... CHECK PARTITION to check one or more partitions; for more information, see Section 13.1.8, “ALTER TABLE Statement”, and Section 22.3.4, “Maintenance of ...option: ...The last row has a Msg_type value of status and the Msg_text normally should be ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
| table_synonym WITH READ LOCK | table_synonym tbl_name [, tbl_name] ... FOR EXPORT } table_synonym: { TABLE | TABLES } The FLUSH statement has several variant forms that clear or reload various internal caches, flush tables, or acquire locks. Note ...Specific flush options might require additional privileges, as indicated in the option ...