{"id":461,"date":"2017-08-30T18:01:02","date_gmt":"2017-08-30T10:01:02","guid":{"rendered":"https:\/\/www.dd-home.top\/?p=461"},"modified":"2017-08-30T18:01:02","modified_gmt":"2017-08-30T10:01:02","slug":"mysql-%e6%b7%bb%e5%8a%a0%e8%81%94%e5%90%88%e7%ba%a6%e6%9d%9f","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=461","title":{"rendered":"MySql \u6dfb\u52a0\u8054\u5408\u7ea6\u675f"},"content":{"rendered":"<p><!--more--><\/p>\n<p>ALTER TABLE db_m_watchitem ADD UNIQUE KEY(number, watchTime);<\/p>\n<p>[SQL]INSERT INTO `weatherservice`.`db_m_watchitem` (`bDelete`, `bForbidden`, `createTime`, `name`, `number`, `statue`, `watchTime`, `watchTimeStr`) VALUES ( &#8216;0&#8217;, &#8216;0&#8217;, &#8216;2017-07-04 14:22:21&#8217;, &#8216;\u91d1\u6e56&#8217;, &#8216;58147&#8217;, &#8216;1&#8217;, &#8216;2017-07-04 00:05:00&#8217;, &#8216;2017-07-04 00:05:00&#8217;);<br \/>\n[Err] 1062 &#8211; Duplicate entry &#8216;58147-2017-07-04 00:05:00&#8217; for key &#8216;number&#8217;<\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-461","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=461"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/461\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}