如何统计有记录限制的联接表的mysql记录?

您必须使用帮助分组语句按供应商分组地址,以便每个供应商正确计算。例如:

SELECT 
   suppliers.id,
   count(*) 
FROM suppliers 
INNER JOIN supplier_addresses ON suppliers.id = supplier_addresses.supplier_id
GROUP BY suppliers.id
LIMIT 5;

如果您想获得5家供应商的地址数量,可以使用子查询。例如:

SELECT count(*)
FROM supplier_addresses 
WHERE supplier_id IN (
   SELECT id
   FROM suppliers
   LIMIT 5)

SELECT count(*)
FROM supplier_addresses 
WHERE supplier_id IN (1,2,3,4,5)