{"id":135,"date":"2019-02-28T13:41:19","date_gmt":"2019-02-28T05:41:19","guid":{"rendered":"http:\/\/adeqing.com\/?p=135"},"modified":"2019-03-06T09:42:14","modified_gmt":"2019-03-06T01:42:14","slug":"mysql-%e7%ae%80%e5%8d%95%e5%8e%bb%e9%87%8d%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/adeqing.com\/index.php\/2019\/02\/28\/default\/135\/","title":{"rendered":"mysql \u7b80\u5355\u53bb\u91cd\u8bed\u53e5"},"content":{"rendered":"<h1>\u7b80\u5355\u53bb\u91cd\u8bed\u53e5<\/h1>\n<h2>\u65b9\u5f0f\u4e00:<\/h2>\n<blockquote>\n<pre># mn_y\u53bb\u91cd\r\nALTER TABLE mn_y ADD UNIQUE (name, href)\r\n\r\nselect * from mn_y limit 1\r\n\r\nselect COUNT(id) from mn_y\r\n\r\nselect count(id) as '\u91cd\u590d\u6b21\u6570',name from mn_y group by name having count(*)&gt;1 order by name desc\r\n\r\ncreate table mn_y_copy select * from mn_y\r\nwhere id in (\r\nselect max(id) from mn_y group by name\r\n)\r\ndrop table mn_y\r\nALTER TABLE mn_y_copy RENAME TO mn_y<\/pre>\n<\/blockquote>\n<h2>\u65b9\u5f0f\u4e8c:<\/h2>\n<blockquote>\n<pre>DELETE from mn_y_copy where id not in (\r\nselect aa.id from (\r\nselect max(id) id from mn_y_copy it group by title\r\n) aa\r\n)<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>mysql<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,10],"tags":[],"_links":{"self":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/135"}],"collection":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/comments?post=135"}],"version-history":[{"count":3,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions"}],"predecessor-version":[{"id":143,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/135\/revisions\/143"}],"wp:attachment":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/media?parent=135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/categories?post=135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/tags?post=135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}