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-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/grant-tables.html
After an account's password has been expired, all operations performed by the account in subsequent connections to the server result in an error until the user issues an ALTER USER statement to establish a new account password. The mysql system ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
The value in effect for CREATE TABLE, or a subsequent ALTER TABLE or TRUNCATE TABLE, is the value used for the life of the table. To free up the memory used by deleted rows, use ALTER TABLE ENGINE=MEMORY to force a table rebuild. The MEMORY storage ...A typical use case for the MEMORY engine involves these characteristics: Operations involving transient, non-critical data such as session management or ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
The TABLESPACE option can be used with ALTER TABLE to move tables between general tablespaces, file-per-table tablespaces, and the system tablespace. Moving Tables Between Tablespaces Using ALTER TABLE ALTER TABLE with the TABLESPACE option can be ... A general tablespace is a shared InnoDB tablespace that is created using CREATE TABLESPACE ...To determine a ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Converting an Existing Table To convert a non-InnoDB table to use InnoDB use ALTER TABLE: ALTER TABLE table_name ENGINE=InnoDB; Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. Cloning the Structure of a ... 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/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/privileges-provided.html
ALTER Enables use of the ALTER TABLE statement to change the structure of tables. Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE TABLESPACE Enables use of statements that create, alter, or drop ...Privileges for database objects such as tables, indexes, views, and stored routines can be granted for specific objects within a database, for all objects of a given type within a database (for example, all tables in a database), or globally for all objects of a given type in all ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tables-table.html
When altering the storage engine of a table, table options that are not applicable to the new storage engine are retained in the table definition to enable reverting the table with its previously defined options to the original storage engine, if ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
In this case, OPTIMIZE TABLE is just mapped to ALTER TABLE. InnoDB Details For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE ... OPTIMIZE TABLE rebuilds the table using the table copy method under the following conditions: When the ...
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 ...