create index name on table (col_list);(alter table tbl_name add index name (col_list);) drop index name on table;(alter table tbl_name drop index name;) alter table tbl_name rename index old_index_name to new_index_name, algorithm=inplace, lock=none; create fulltext index name on table(column); create table geom (g geometry not null);alter table geom add spatial index(g), algorithm=inplace, lock=shared; alter table tbl_name drop index i1, add index i1(key_part,...) using btree, algorithm=inplace;
alter table tbl_name add primary key (column) alter table tbl_name drop primary key alter table tbl_name drop primary key, add primary key (column)
alter table tbl_name add column column_name column_definition, alter table tbl_name drop column column_name alter table tbl change old_col_name new_col_name data_type alter table tbl_name modify column col_name column_definition first alter table tbl_name change c1 c1 bigint alter table tbl_name change column c1 c1 varchar(255) alter table tbl_name alter column col set default literal alter table tbl alter column col drop default alter table table auto_increment=next_value alter table tbl_name modify column column_name data_type null alter table tbl_name modify column column_name data_type not null alter table t1 modify column c1 enum('a', 'b', 'c', 'd')
alter table t1 add column (c2 int generated always as (c1 + 1) stored) alter table t1 modify column c2 int generated always as (c1 + 1) stored first alter table t1 drop column c2, algorithm=inplace, lock=none; alter table t1 add column (c2 int generated always as (c1 + 1) virtual) alter table t1 modify column c2 int generated always as (c1 + 1) virtual first alter table t1 drop column c2, algorithm=inplace
alter table tbl1 add constraint fk_name foreign key index (col1)references tbl2(col2) referential_actions; alter table tbl drop foreign key fk_name;
alter table tbl_name row_format = row_format alter table tbl_name key_block_size = value alter table tbl_name stats_persistent=0, stats_sample_pages=20, stats_auto_recalc=1, algorithm=inplace, lock=none; alter table tbl_name character set = charset_name, algorithm=inplace, lock=none; alter table tbl_name convert to character set charset_name, algorithm=copy; optimize table tbl_name; alter table tbl_name force, algorithm=inplace, lock=none; alter table tbl_name engine=innodb, algorithm=inplace, lock=none; alter table old_tbl_name rename to new_tbl_name, algorithm=inplace, lock=none;
alter table tbl_name encryption='y', algorithm=copy;
如对本文有疑问, 点击进行留言回复!!
网友评论