SHOW ALTER

Description

This statement is used to show the execution of various modification tasks currently under way. Grammar: SHOW ALTER [CLUSTER | TABLE [COLUMN | ROLLUP] [FROM db_name]];

Explain: TABLE COLUMN：Shows the task of alter table column. Support grammar [WHERE TableName|CreateTime|FinishTime|State] [ORDER BY] [LIMIT] TABLE ROLLUP: Shows the task of creating or deleting ROLLUP index If db_name is not specified, use the current default DB CLUSTER: Show the cluster operation related tasks (only administrators use! To be realized…

example

  1. Show the task execution of all modified columns of default DB SHOW ALTER TABLE COLUMN;

  2. Show the last task execution of modified columns of some table SHOW ALTER TABLE COLUMN WHERE TableName = “table1” ORDER BY CreateTime LIMIT 1;

  3. Show the execution of tasks to create or delete ROLLUP index for specified DB SHOW ALTER TABLE ROLLUP FROM example_db;

  4. Show cluster operations related tasks (only administrators use! To be realized… SHOW ALTER CLUSTER;

keyword

SHOW,ALTER