MySQL Bulk value Insert batch update case

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 the "www" then 22211 when the ' Eee ' then 333111 END WHERE weeks= ' 222 ';

Because the table structure is limited, so the entity one by one can not be used to correspond, so can only use HQL

Hibernate HQL Bulk Insert did not find the inherent method, so the use of hair, the speed increased a lot

MySQL Bulk value Insert batch update case