CREATE TEMPORARY TABLE `lc` (`count` MEDIUMINT,`ba_id` BIGINT,PRIMARY KEY (`ba_id`)); LOAD DATA LOCAL INFILE "/home/master/builder/work/tmp.mysql-functions.unimportant_query.2023-03-30T11:49:02.1cDPjD.infile.1" INTO TABLE `lc`(`count`,`ba_id`); UPDATE `build_assignments` LEFT JOIN `lc` ON `build_assignments`.`id`=`lc`.`ba_id` SET `build_assignments`.`currently_blocking`=`lc`.`count`;