mysql

1、行行比较

SELECT * FROM t_ware_sale_statistics
WHERE (business id,ware inside code)
IN ((100120609，5169),(100120609,138,100121327,14418,(100121327,14419));

select * from t_ware sale statistics
where (business_id,ware_inside_code) IN (
<foreach collection="businesswareList" item="businessware" separator="">
(#businessware.businessId},#{businessware.wareInsideCode})
</foreach>

)

 2、添加
ALTER TABLE 表名 ADD COLUMN 字段名 数据类型 [约束条件] COMMENT '字段注释';

ALTER TABLE t_finance_order ADD COLUMN order_type VARCHAR(50) NOT NULL DEFAULT 'normal' COMMENT '订单类型';

ALTER TABLE 表名 ADD COLUMN 字段名 数据类型 [约束条件] COMMENT '字段注释';