有SQL语句:
SELECT p.*, f.* FROM uchome_posts p LEFT JOIN uchome_postsfield f ON p.pid = f.pid WHERE p.tid = '1557' AND p.HASH = '1b622139d19b456e5ea72c8f2056021d' ORDER BY p.pid ASC LIMIT 0, 100
但是解释之后如下图:
很显然索引没有生效,求如何创建一个表关联的正确索引。
Copyright 2014-2026 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
认证高级PHP讲师