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
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;
创建一张临时表,
临时表会在当前会话有效,如果断开会话,则临时表就会被自动删除掉