mysql 常用脚本整理

ALTER table summer_xxx.xxx_table ADD column_name TINYINT(1) NOT NULL COMMENT ‘是否核算‘ after office_id;

`disabled_date` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT ‘删除时间‘

alter table summer_xxx.xxx_table modify column column_name decimal(7,3) DEFAULT NULL COMMENT ‘xxxxx‘;

alter table summer_xxx.xxx_table drop index INDEX_UNIQUE_ANALYZE_ASSEMENT_SCORE;

CREATE UNIQUE INDEX INDEX_NAME ON summer_xxx.xxx_table ( `assement_date`, `office_id`, `tenant_code`, `enabled`, `disabled_date` ) USING BTREE;

CREATE INDEX index_name ON table_name (column_list)

show index from tblname;

<if test="@com.xxx.article.common.util.collection.CollectionUtil@isNotEmpty(query.articleIdList)"> 
　　AND t1.article_id in
   <foreach collection="query.articleIdList" index="index" item="item" open="(" separator="," close=")"> 
　　　　#{item} 
　　</foreach> 
</if>