In an effort to speed up my database updates, I’ve been looking for ways to batch some of my updates. CASE seems like the way to go: mysql> create table bar(a tinyint, b tinyint); Query OK, 0 rows affected (0.02 sec) mysql> insert into bar(a) values(1), (2), (3), (4), (5); Query OK, 5 rows affected…