PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
avoid_temporal_upgrade Command-Line Format --avoid-temporal-upgrade[={OFF|ON}] Deprecated Yes System Variable avoid_temporal_upgrade Scope Global Dynamic Yes Type Boolean Default Value OFF This variable controls whether ALTER TABLE implicitly ...For ... The MySQL server maintains many system variables that affect its ...
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/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/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/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-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/partitioning-management-range-list.html
Dropping a partition from a table that is partitioned by either RANGE or by LIST can be accomplished using the ALTER TABLE statement with the DROP PARTITION option. To drop the partition named p2, execute the following command: mysql> ALTER TABLE tr ...For information about working with tables that are partitioned by hash or key, see Section 22.3.2, “Management of HASH and KEY ... Adding and dropping of ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
ALTER TABLE now supports a RENAME INDEX clause that renames an index. These InnoDB enhancements were added: VARCHAR column size can be increased using an in-place ALTER TABLE, as in this example: ALTER TABLE t1 ALGORITHM=INPLACE, CHANGE COLUMN c1 c1 ...The server now requires account rows in the mysql.user system table to have a nonempty plugin column value and disables accounts with an empty ...
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/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...