mysql 临时表的应用

CREATE TEMPORARY TABLE IF NOT EXISTS testTmpTable ENGINE = MEMORY AS
SELECT a.* FROM (
SELECT
a.id
b.name
FROM testA a

JOIN testB b ON a.id = b.stu_id
WHERE a.id = 10
ORDER BY b.stu_id,b.id DESC

) a GROUP BY a.stu_id;

创建一张临时表，

临时表会在当前会话有效，如果断开会话，则临时表就会被自动删除掉