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/alter-instance.html
The statement supports these actions: ALTER INSTANCE ROTATE INNODB MASTER KEY This action rotates the master encryption key used for InnoDB tablespace encryption. ALTER INSTANCE ROTATE INNODB MASTER KEY ALTER INSTANCE, introduced in MySQL 5.7.11, ...To perform this action, a keyring plugin must be installed and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
ALTER {DATABASE | SCHEMA} db_name UPGRADE DATA DIRECTORY NAME alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name } ALTER DATABASE enables you to change the overall characteristics of a database. Use ...
https://dev.mysql.com/doc/refman/5.7/en/alter-server.html
ALTER SERVER server_name OPTIONS (option [, option] ...) Alters the server information for server_name, adjusting any of the options permitted in the CREATE SERVER statement. For example, to update the USER option: ALTER SERVER s OPTIONS (USER ...
https://dev.mysql.com/doc/refman/5.7/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...
https://dev.mysql.com/doc/refman/5.7/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ... We sometimes refer to this as a “copying” or “offline” ALTER TABLE. DML operations are not permitted concurrently with a copying ALTER TABLE. The mysqld ...For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this ...
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 ...