mysql - SQL 查询中的 LIMIT 返回指定的最大数量

Question

出于某种原因，这总是返回 31 行而不是预期的 2 行。不太确定发生了什么？

SELECT 
    ins_by          AS userid,
    wds_user_id     AS customer, 
    wds_address_id  AS billing,
    (
        SELECT 
            wds_address_id  AS shipping
        FROM 
            wds_user_address B
        WHERE 
            ins_by != "GUEST" 
        AND 
            wds_address_type_id = 2 
        AND 
            B.ins_by = A.ins_by
    ) AS shipping
FROM 
    wds_user_address A 
WHERE 
    ins_by != "GUEST" 
AND 
    wds_address_type_id = 1
ORDER BY id ASC 
LIMIT 30, 32;

期待

+---------------------+----------+---------+----------+
| userid              | customer | billing | shipping |
+---------------------+----------+---------+----------+
| FOO@GMAIL.COM       |      121 |     185 |      186 |
| BAR@GMAIL.COM       |      123 |     189 |      190 |
+---------------------+----------+---------+----------+

Answer 1

你的语句告诉 MySQL 返回 32 行。

LIMIT 30,32

意思是“跳过前 30 行，然后返回接下来的 32 行”。

如果您想跳过前 30 行并仅返回接下来的 2 行，则需要修改您的 LIMIT 子句。