{"id":377,"date":"2022-05-15T11:19:28","date_gmt":"2022-05-15T03:19:28","guid":{"rendered":"http:\/\/usei.cn\/?p=377"},"modified":"2022-05-15T11:19:29","modified_gmt":"2022-05-15T03:19:29","slug":"mysql5-7-json-%e6%95%b0%e6%8d%ae%e5%ad%98%e5%82%a8","status":"publish","type":"post","link":"https:\/\/usei.cn\/index.php\/2022\/05\/15\/mysql5-7-json-%e6%95%b0%e6%8d%ae%e5%ad%98%e5%82%a8\/","title":{"rendered":"Mysql5.7 JSON \u6570\u636e\u5b58\u50a8"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">1.\u521b\u5efajson \u6570\u636e\u7c7b\u578b\u7684\u5b57\u6bb5<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">2.\u67e5\u8be2 JSON_EXTRACT<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>select JSON_EXTRACT(value,'$.name') from sys_setting<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3.\u66f4\u65b0 JSON_SET<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>update sys_setting set value =  JSON_SET(value,'$.name','222333') where `key`='payment'<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u521b\u5efajson \u6570\u636e\u7c7b\u578b\u7684\u5b57\u6bb5 2.\u67e5\u8be2 JSON_EXTRACT 3.\u66f4\u65b0 JSON_SET<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48],"tags":[],"class_list":["post-377","post","type-post","status-publish","format-standard","hentry","category-48"],"_links":{"self":[{"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/posts\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/comments?post=377"}],"version-history":[{"count":1,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/posts\/377\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/media?parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/categories?post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/usei.cn\/index.php\/wp-json\/wp\/v2\/tags?post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}