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;