MySQL利用临时表存储和操作数据

-- 查找无台席号并且未配置CVR录像的资源ID，并存入临时表中
DROP TEMPORARY TABLE IF EXISTS tmp_table;
CREATE TEMPORARY TABLE tmp_table 
    SELECT DISTINCT res.ID AS res_id FROM regionres res 
    LEFT JOIN recordcvr cvr ON cvr.nCamID = res.ID
    WHERE res.strGunNo IS NULL AND cvr.nCamID IS NULL;

-- 删除查询到的结果
DELETE FROM regionres WHERE ID IN (SELECT res_id FROM tmp_table);

-- 删除临时表
DROP TEMPORARY TABLE IF EXISTS tmp_table;