{"id":201,"date":"2014-08-21T18:44:40","date_gmt":"2014-08-21T18:44:40","guid":{"rendered":"http:\/\/blog.chen-hongyi.com\/?p=201"},"modified":"2014-08-21T18:44:40","modified_gmt":"2014-08-21T18:44:40","slug":"use-sql_calc_found_rows-in-mysql","status":"publish","type":"post","link":"https:\/\/chen-hongyi.com\/?p=201","title":{"rendered":"use SQL_CALC_FOUND_ROWS  in mysql"},"content":{"rendered":"<div class=\"article_title\">\n<h1><span class=\"link_title\"><a href=\"http:\/\/blog.csdn.net\/maray\/article\/details\/5525296\"> MYSQL\u4e2d\u7edf\u8ba1\u67e5\u8be2\u7ed3\u679c\u603b\u884c\u6570\u7684\u4fbf\u6377\u65b9\u6cd5\u3010\u8f6c\u8f7d\u3011 <\/a><\/span><\/h1>\n<\/div>\n<div class=\"article_manage\"><span class=\"link_categories\"> \u5206\u7c7b\uff1a <a href=\"http:\/\/blog.csdn.net\/maray\/article\/category\/330000\">\u5e94\u7528\u5f00\u53d1<\/a> <\/span> <span class=\"link_postdate\">2010-04-24 21:55<\/span> <span class=\"link_view\" title=\"\u9605\u8bfb\u6b21\u6570\">1913\u4eba\u9605\u8bfb<\/span> <span class=\"link_comments\" title=\"\u8bc4\u8bba\u6b21\u6570\"><a href=\"http:\/\/blog.csdn.net\/maray\/article\/details\/5525296#comments\">\u8bc4\u8bba<\/a>(0)<\/span> <span class=\"link_collect\"><a title=\"\u6536\u85cf\">\u6536\u85cf<\/a><\/span> <span class=\"link_report\"><a title=\"\u4e3e\u62a5\" href=\"http:\/\/blog.csdn.net\/maray\/article\/details\/5525296#report\">\u4e3e\u62a5<\/a><\/span><\/div>\n<div class=\"tag2box\"><a href=\"http:\/\/www.csdn.net\/tag\/mysql\" target=\"_blank\">mysql<\/a><a href=\"http:\/\/www.csdn.net\/tag\/sql\" target=\"_blank\">sql<\/a><a href=\"http:\/\/www.csdn.net\/tag\/wordpress\" target=\"_blank\">wordpress<\/a><a href=\"http:\/\/www.csdn.net\/tag\/query\" target=\"_blank\">query<\/a><a href=\"http:\/\/www.csdn.net\/tag\/list\" target=\"_blank\">list<\/a><a href=\"http:\/\/www.csdn.net\/tag\/function\" target=\"_blank\">function<\/a><\/div>\n<p><strong>\u8f6c\u81ea\uff1a<a href=\"http:\/\/ginew.blog.163.com\/\">http:\/\/ginew.blog.163.com\/<\/a><br \/>\n<\/strong><br \/>\n\u4eca\u5929\u9605\u8bfb wordpress\u4ee3\u7801\u65f6\uff0c\u53d1\u73b0\u4e00<a name=\"baidusnap3\"><\/a><strong>\u4e2a<\/strong><strong>MYSQL<\/strong>\u7684\u5173\u952e\u8bcd SQL_CALC_FOUND_ROWS \u67e5\u770b\u624b\u518c\u540e\u53d1\u73b0\u6b64\u5173\u952e\u8bcd\u7684\u4f5c\u7528\u662f\u5728\u67e5\u8be2\u65f6<strong>\u7edf\u8ba1<\/strong>\u6ee1\u8db3\u8fc7\u6ee4\u6761\u4ef6\u540e\u7684<strong>\u7ed3\u679c<\/strong>\u7684\u603b<strong>\u6570<\/strong>\uff08\u4e0d\u53d7 Limit \u7684\u9650\u5236\uff09<\/p>\n<p>\u4f8b\u5982\uff1a SELECT SQL_CALC_FOUND_ROWS tid FROM cdb_threads WHERE fid=14 LIMIT 1,10;<br \/>\n\u5047\u8bbe\u6ee1\u8db3\u6761\u4ef6\u7684\u67091000\u6761\uff0c\u8fd9\u91cc\u8fd4\u56de10\u6761\u3002\u7acb\u5373\u4f7f\u7528 SELECT found_rows() AS rowcount; \u5219\u8fd4\u56de\u7684 rowcount \u4e3a1000\uff1b<\/p>\n<p>\u8fd9\u6837\u8282\u7701\u4e86SELECT count(*) AS rowcount\u7684\u91cd\u590d\u67e5\u8be2\uff0c\u53ef\u4ee5\u8282\u7701\u6bd4\u8f83\u53ef\u89c2\u7684\u65f6\u95f4.<\/p>\n<p>&nbsp;<\/p>\n<p>From: http:\/\/blog.csdn.net\/maray\/article\/details\/5525296<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MYSQL\u4e2d\u7edf\u8ba1\u67e5\u8be2\u7ed3\u679c\u603b\u884c\u6570\u7684\u4fbf\u6377\u65b9\u6cd5\u3010\u8f6c\u8f7d\u3011 \u5206\u7c7b\uff1a \u5e94\u7528\u5f00\u53d1 2010-0 &hellip; <a href=\"https:\/\/chen-hongyi.com\/?p=201\">\u7ee7\u7eed\u9605\u8bfb <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=201"}],"version-history":[{"count":1,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":202,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=\/wp\/v2\/posts\/201\/revisions\/202"}],"wp:attachment":[{"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chen-hongyi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}