{"id":30480,"date":"2024-11-25T15:14:37","date_gmt":"2024-11-25T07:14:37","guid":{"rendered":"https:\/\/fwq.ai\/blog\/30480\/"},"modified":"2024-11-25T15:14:37","modified_gmt":"2024-11-25T07:14:37","slug":"dede%e6%80%8e%e4%b9%88%e7%bb%99dede_sys_enum%e6%b7%bb%e5%8a%a0%e5%ad%97%e6%ae%b5father","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/30480\/","title":{"rendered":"dede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father"},"content":{"rendered":"<p style=\"text-align: center\"><strong><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/020\/5dfad9a6d68b7170.jpg\" class=\"aligncenter\" title=\"dede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father\u63d2\u56fe\" alt=\"dede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father\u63d2\u56fe\" \/><\/strong><\/p>\n<p><strong>dede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father?<\/strong><\/p>\n<p>dede\u63d0\u4f9b\u4e86\u8054\u52a8\u6a21\u578b\uff0c\u5bf9\u5e94\u6570\u636e\u5e93\u8868dede_sys_enum\uff0c\u6dfb\u52a0\u4e00\u4e2a\u7236\u8282\u70b9\u5b57\u6bb5\u3002\u63d0\u4f9b\u89e6\u53d1\u5668\u81ea\u52a8\u66f4\u65b0\uff0c\u4e0b\u9762\u6709\u4e2a\u793a\u4f8b\uff0c\u5927\u5bb6\u53ef\u4ee5\u53c2\u8003\u4e0b<\/p>\n<p>&nbsp;&nbsp;\u63a8\u8350\u5b66\u4e60\uff1a<\/p>\n<p>\u4e8b\u60c5\uff1a&nbsp;<\/p>\n<p>dede\u63d0\u4f9b\u4e86\u8054\u52a8\u6a21\u578b\uff0c\u5bf9\u5e94\u6570\u636e\u5e93\u8868dede_sys_enum\uff0c\u6dfb\u52a0\u4e00\u4e2a\u7236\u8282\u70b9\u5b57\u6bb5\u3002\u63d0\u4f9b\u89e6\u53d1\u5668\u81ea\u52a8\u66f4\u65b0\u3002&nbsp;<\/p>\n<p>\u89e3\u51b3\uff1a&nbsp;<\/p>\n<p>\u89e6\u53d1\u5668\u4fee\u6539father\u5b57\u6bb5\u7684\u503c&nbsp;<\/p>\n<p>\u4ee3\u7801\u5982\u4e0b:<\/p>\n<pre>DELIMITER&nbsp;$$&nbsp;\nCREATE&nbsp;TRIGGER&nbsp;`dede_sys_enum_AINS`&nbsp;\nBEFORE&nbsp;INSERT&nbsp;ON&nbsp;dede_sys_enum&nbsp;\nFOR&nbsp;EACH&nbsp;ROW&nbsp;\nBEGIN&nbsp;\nSET&nbsp;new.father=REPLACE(new.evalue,new.evalue,FLOOR(new.evalue\/500)*500);&nbsp;\nend<\/pre>\n<p> \u767b\u5f55\u540e\u590d\u5236 <\/p>\n<p>\u4ee5\u4e0a\u5c31\u662fdede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>dede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father? dede\u63d0\u4f9b\u4e86\u8054\u52a8\u6a21\u578b\uff0c\u5bf9\u5e94\u6570\u636e\u5e93\u8868dede_sys_enum\uff0c\u6dfb\u52a0\u4e00\u4e2a\u7236\u8282\u70b9\u5b57\u6bb5\u3002\u63d0\u4f9b\u89e6\u53d1\u5668\u81ea\u52a8\u66f4\u65b0\uff0c\u4e0b\u9762\u6709\u4e2a\u793a\u4f8b\uff0c\u5927\u5bb6\u53ef\u4ee5\u53c2\u8003\u4e0b &nbsp;&nbsp;\u63a8\u8350\u5b66\u4e60\uff1a \u4e8b\u60c5\uff1a&nbsp; dede\u63d0\u4f9b\u4e86\u8054\u52a8\u6a21\u578b\uff0c\u5bf9\u5e94\u6570\u636e\u5e93\u8868dede_sys_enum\uff0c\u6dfb\u52a0\u4e00\u4e2a\u7236\u8282\u70b9\u5b57\u6bb5\u3002\u63d0\u4f9b\u89e6\u53d1\u5668\u81ea\u52a8\u66f4\u65b0\u3002&nbsp; \u89e3\u51b3\uff1a&nbsp; \u89e6\u53d1\u5668\u4fee\u6539father\u5b57\u6bb5\u7684\u503c&nbsp; \u4ee3\u7801\u5982\u4e0b: DELIMITER&nbsp;$$&nbsp; CREATE&nbsp;TRIGGER&nbsp;`dede_sys_enum_AINS`&nbsp; BEFORE&nbsp;INSERT&nbsp;ON&nbsp;dede_sys_enum&nbsp; FOR&nbsp;EACH&nbsp;ROW&nbsp; BEGIN&nbsp; SET&nbsp;new.father=REPLACE(new.evalue,new.evalue,FLOOR(new.evalue\/500)*500);&nbsp; end \u767b\u5f55\u540e\u590d\u5236 \u4ee5\u4e0a\u5c31\u662fdede\u600e\u4e48\u7ed9dede_sys_enum\u6dfb\u52a0\u5b57\u6bb5father\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-30480","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=30480"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30480\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=30480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=30480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=30480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}