mysql表连接,左表是大表,右表是小表,大表可以使用派生查询来提高查询效率,比如:
SELECT * FROM
(SELECT * FROM table_1 LIMIT 5) as subq
LEFT JOIN table_2 ON subq.id = table_2.id WHERE 1
mysql表连接,左表是大表,右表是小表,大表可以使用派生查询来提高查询效率
最新推荐文章于 2023-05-11 10:49:35 发布
mysql表连接,左表是大表,右表是小表,大表可以使用派生查询来提高查询效率,比如:
SELECT * FROM
(SELECT * FROM table_1 LIMIT 5) as subq
LEFT JOIN table_2 ON subq.id = table_2.id WHERE 1