Shulou(Shulou.com)06/01 Report--

The query data in xml query price contains list, so collection is required.

.... ....

Such a query system encapsulated general paging query is incorrect, so you need to add your own SQL paging solution.

SELECT you.nick_name, yo.id o_id, yo.user_id o_user_id FROM ( SELECT * FROM youpin_order WHERE 1 = 1 and `status` = #{status} LIMIT #{page}, #{limit} ) yo LEFT JOIN XXX yop ON yo.id = yop.order_id LEFT JOIN XXXX you ON yo.user_id = you.id

When you pass in parameters, you need to calculate

(offset - 1) * limit, limit

summary

The above is a solution to the mysql one-to-many associated query paging error problem introduced by Xiaobian. I hope it will help you. If you have any questions, please leave a message to me. Xiaobian will reply to you in time. Thank you very much for your support!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.