mysql 批量value插入 批量update case when then
insert into tableName(type1,type2,type3) values (“q1”,”w1”,”e1”),( “q2”,”w2”,”e2”) ,( “q3”,”w3”,”e3”);
UPDATE app_history_statistics_by_hour SET h00 = CASE statisticalType WHEN "qqq" THEN 11111 WHEN "www" THEN 22211 WHEN 'eee' THEN 333111 ELSE 0 END WHERE weeks='222';
UPDATE app_history_statistics_by_hour
SET h00 = CASE id
WHEN 1 THEN 3
WHEN 2 THEN 4
WHEN 3 THEN 5
END,
h01 = CASE id
WHEN 1 THEN 'New Title 1'
WHEN 2 THEN 'New Title 2'
WHEN 3 THEN 'New Title 3'
END
WHERE id IN (1,2,3)
由于表结构有限,所以没能用实体一一对应,所以只能用hql
hibernate hql 批量插入 没找到固有的方法,所以 用以上方法,速度提升很多