tencent cloud

RENAME TABLE tbl_name TO new_tbl_name

CREATE TABLE [IF NOT EXISTS] tbl_name (create_definition,...) 
CREATE TABLE new_tbl LIKE orig_tbl;
CREATE TABLE new_tbl AS SELECT * FROM orig_tbl;

ALTER TABLE t1 MODIFY b INT NOT NULL;
ALTER TABLE t1 CHANGE b a INT NOT NULL;

ALTER TABLE table_name
  ADD new_column_name column_definition
    [ FIRST | AFTER column_name ];

Alter table t2 DROP [COLUMN] col_name

truncate table a;

drop table a;