1、问题:如下SQL查询时间过长
SELECT id
FROM game
WHERE id in (SELECT id FROM game)
2、解决方案:使用表别名
SELECT id
FROM game
WHERE id in (SELECT a.id FROM (SELECT id FROM game) as a)
1、问题:如下SQL查询时间过长
SELECT id
FROM game
WHERE id in (SELECT id FROM game)
2、解决方案:使用表别名
SELECT id
FROM game
WHERE id in (SELECT a.id FROM (SELECT id FROM game) as a)