{"id":878,"date":"2021-11-08T11:06:01","date_gmt":"2021-11-08T02:06:01","guid":{"rendered":"https:\/\/blog.tkouen.mydns.jp\/wordpress\/?p=878"},"modified":"2021-11-08T11:13:32","modified_gmt":"2021-11-08T02:13:32","slug":"mysql%e5%89%8d%e5%be%8c%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e5%8f%96%e5%be%97%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/devlog.nb3.jp\/wordpress\/878","title":{"rendered":"[mysql]\u524d\u5f8c\u306e\u30c7\u30fc\u30bf\u53d6\u5f97[\u30e1\u30e2]"},"content":{"rendered":"<p>\u304a\u4e45\u3057\u3076\u308a\u3067\u3059<\/p>\n<p>\u3042\u307e\u308a\u4f7f\u3046\u6a5f\u4f1a\u304c\u306a\u3044\u3051\u3069mysql\u3067\u524d\u5f8c\u306e\u884c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u304c\u3057\u305f\u3044\u5834\u5408\u306esql\u306e\u66f8\u304d\u65b9\u3092\u30e1\u30e2\u3057\u3066\u304a\u304d\u307e\u3059\u3002<br \/>\n\u4f8b\u3068\u3057\u3066WordPress\u306e\u6295\u7a3f\u30c6\u30fc\u30d6\u30eb<\/p>\n<pre>SELECT \r\n@cur_id := ID as ID,\r\npost_date,\r\npost_title,\r\n@prev_id := (SELECT ID FROM wp_posts WHERE post_type='post' AND post_status='publish' AND ID<@cur_id ORDER BY ID DESC LIMIT 1) as prev_ID,\r\n(SELECT post_title FROM wp_posts WHERE ID=@prev_id ) as prev_title,\r\n@next_id := (SELECT ID FROM wp_posts WHERE post_type='post' AND post_status='publish' AND ID>@cur_id ORDER BY ID ASC LIMIT 1) as next_ID,\r\n(SELECT post_title FROM wp_posts WHERE ID=@next_id ) as next_title\r\nFROM `wp_posts`\r\nWHERE post_type='post' \r\nAND post_status='publish'\r\nORDER BY ID DESC<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u304a\u4e45\u3057\u3076\u308a\u3067\u3059 \u3042\u307e\u308a\u4f7f\u3046\u6a5f\u4f1a\u304c\u306a\u3044\u3051\u3069mysql\u3067\u524d\u5f8c\u306e\u884c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u304c\u3057\u305f\u3044\u5834\u5408\u306esql\u306e\u66f8\u304d\u65b9\u3092\u30e1\u30e2\u3057\u3066\u304a\u304d\u307e\u3059\u3002 \u4f8b\u3068\u3057\u3066WordPress\u306e\u6295\u7a3f\u30c6\u30fc\u30d6\u30eb SELECT @cur_id := ID as ID,  &hellip; <a href=\"https:\/\/devlog.nb3.jp\/wordpress\/878\">\u7d9a\u304d\u3092\u8aad\u3080 <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":[4],"tags":[172],"class_list":["post-878","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-172"],"_links":{"self":[{"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/posts\/878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/comments?post=878"}],"version-history":[{"count":2,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/posts\/878\/revisions"}],"predecessor-version":[{"id":880,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/posts\/878\/revisions\/880"}],"wp:attachment":[{"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/media?parent=878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/categories?post=878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devlog.nb3.jp\/wordpress\/wp-json\/wp\/v2\/tags?post=878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}