mysql ddl online

新增字段：

alter table biz_order ADD vin_id bigint(20) unsigned NULL COMMENT 'vin卡',ALGORITHM = INPLACE,LOCK = NONE;

更新字段

alter table rec_cg_order modify cg_no varchar(27) NOT NULL,ALGORITHM = INPLACE,LOCK = NONE;

新增索引

ALTER TABLE wxcp_client ADD INDEX idx_mp_client_id (mp_client_id),ALGORITHM = INPLACE,LOCK = NONE;

ALTER TABLE qw_session ADD UNIQUE INDEX account_conversation_id_IDX (account_id,conversation_id),ALGORITHM = INPLACE,LOCK = NONE;

ALTER TABLE qw_session ADD UNIQUE INDEX conversation_account_id_IDX (conversation_id,account_id),ALGORITHM = INPLACE,LOCK = NONE;

ALTER TABLE mp_client ADD INDEX qw_id_IDX (qw_id),ALGORITHM = INPLACE,LOCK = NONE;

https://blog.csdn.net/weixin_41519463/article/details/107689821