logo  

运维备忘录

运维备忘录
作者: 陈安廉

摘要:软件开发进阶系列


mysql ddl online


2022-06-01 17:18:30

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



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