{"id":806,"date":"2026-08-01T15:47:49","date_gmt":"2026-08-01T07:47:49","guid":{"rendered":"https:\/\/book.yuekegu.com\/index.php\/2026\/08\/01\/%e6%95%99%e7%a0%94%e7%9f%a5%e8%af%86%e4%bd%93%e7%b3%bb%e5%ae%9a%e5%88%b6%e6%8a%80%e8%83%bd%ef%bc%88%e6%95%99%e6%9d%90%e7%9b%ae%e5%bd%95%e7%9f%a5%e8%af%86%e7%82%b9%e7%ae%a1%e7%90%86%ef%bc%89\/"},"modified":"2026-08-01T15:47:49","modified_gmt":"2026-08-01T07:47:49","slug":"%e6%95%99%e7%a0%94%e7%9f%a5%e8%af%86%e4%bd%93%e7%b3%bb%e5%ae%9a%e5%88%b6%e6%8a%80%e8%83%bd%ef%bc%88%e6%95%99%e6%9d%90%e7%9b%ae%e5%bd%95%e7%9f%a5%e8%af%86%e7%82%b9%e7%ae%a1%e7%90%86%ef%bc%89","status":"publish","type":"post","link":"https:\/\/book.yuekegu.com\/index.php\/2026\/08\/01\/%e6%95%99%e7%a0%94%e7%9f%a5%e8%af%86%e4%bd%93%e7%b3%bb%e5%ae%9a%e5%88%b6%e6%8a%80%e8%83%bd%ef%bc%88%e6%95%99%e6%9d%90%e7%9b%ae%e5%bd%95%e7%9f%a5%e8%af%86%e7%82%b9%e7%ae%a1%e7%90%86%ef%bc%89\/","title":{"rendered":"\u6559\u7814\u77e5\u8bc6\u4f53\u7cfb\u5b9a\u5236\u6280\u80fd\uff08\u6559\u6750\u76ee\u5f55+\u77e5\u8bc6\u70b9\u7ba1\u7406\uff09"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u4e00\u3001edu-textbook-catalog \u2014 \u5c0f\u521d\u9ad8\u6559\u6750\u76ee\u5f55\u7ba1\u7406<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6280\u80fd\u7b80\u4ecb\uff1a<\/strong>\u7ba1\u7406 <code>sq_catalog<\/code> \u6559\u6750\u76ee\u5f55\u6811\uff08\u5b66\u79d1\u2192\u7248\u672c\u2192\u6559\u6750\u2192\u7ae0\u2192\u8282\uff09\uff0c\u652f\u6301\u76ee\u5f55\u7ed3\u6784\u8bbe\u8ba1\u3001\u6570\u636e\u9002\u914d\u5bfc\u51fa\u3001\u53bb\u91cd\u5408\u5e76\u3001\u5c42\u7ea7\u6821\u9a8c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u529f\u80fd<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u6559\u6750\u76ee\u5f55\u6811\u7ba1\u7406\uff08\u8d44\u6599\u5e93\u2192\u5b66\u6bb5\u2192\u5b66\u79d1\u2192\u7248\u672c\u2192\u6559\u6750\u2192\u7ae0\u2192\u8282\uff09<\/li><li>\u5b66\u79d1 course ID \u6620\u5c04\uff08\u9ad8\u4e2d1-9\uff0c\u521d\u4e2d25-33\uff09<\/li><li>\u6559\u6750\u6570\u636e\u5bfc\u51fa\/\u5bfc\u5165\uff08sq_catalog.json\uff09<\/li><li>\u76ee\u5f55\u2194\u77e5\u8bc6\u70b9\u6620\u5c04\u589e\u5f3a<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001edu-knowledge-point \u2014 \u6559\u5b66\u77e5\u8bc6\u70b9\u4f53\u7cfb\u7ba1\u7406<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6280\u80fd\u7b80\u4ecb\uff1a<\/strong>\u7ba1\u7406 <code>sq_knowledge<\/code> \u77e5\u8bc6\u70b9\u6811\uff08\u5b66\u79d1\u2192\u6a21\u5757\u2192\u77e5\u8bc6\u70b9\u2192\u9898\u578b\u53f6\u8282\u70b9\uff09\uff0c\u652f\u6301\u77e5\u8bc62\u6574\u5408\u3001\u5c42\u7ea7\u91cd\u5efa\u3001subject_name \u6821\u9a8c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6838\u5fc3\u529f\u80fd<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u77e5\u8bc6\u70b9\u6811\u7ba1\u7406\uff08\u4e13\u9898\u8d44\u6599\u2192\u5b66\u79d1\u2192\u6a21\u5757\u2192\u77e5\u8bc6\u70b9\u2192\u9898\u578b\uff09<\/li><li>sq_knowledge2 \u6570\u636e\u6574\u5408<\/li><li>subject_name \u4e2d\u6587\u4e00\u81f4\u6027\u6821\u9a8c<\/li><li>\u77e5\u8bc6\u70b9-\u9898\u76ee\u5173\u8054\u67e5\u8be2<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001edu-knowledge-expert \u2014 \u6559\u7814\u77e5\u8bc6\u4f53\u7cfb\u4e13\u5bb6\uff08\u89d2\u8272\uff09<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u89d2\u8272\u7b80\u4ecb\uff1a<\/strong>\u4f5c\u4e3a\u5c0f\u521d\u9ad8\u6559\u5b66\u6559\u7814\u4e13\u5bb6\uff0c\u4ee5\u8bfe\u7a0b\u6807\u51c6\uff08\u65b0\u8bfe\u6807\uff09\u4e3a\u4f9d\u636e\uff0c\u89c4\u5212\u548c\u7ba1\u7406\u6559\u6750\u76ee\u5f55\u4e0e\u77e5\u8bc6\u70b9\u4f53\u7cfb\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u804c\u8d23<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>\u6570\u636e\u67b6\u6784\u5e08<\/strong>\uff1a\u8bbe\u8ba1\u6559\u6750\u76ee\u5f55\u4e0e\u77e5\u8bc6\u70b9\u7684\u5c42\u7ea7\u7ed3\u6784<\/li><li><strong>\u6559\u7814\u987e\u95ee<\/strong>\uff1a\u628a\u5173\u77e5\u8bc6\u70b9\u5212\u5206\u662f\u5426\u7b26\u5408\u6559\u5b66\u5b9e\u9645<\/li><li><strong>\u8d28\u91cf\u7ba1\u7406\u5458<\/strong>\uff1a\u6821\u9a8c\u6570\u636e\u4e00\u81f4\u6027\u3001\u5b8c\u6574\u6027\u3001\u89c4\u8303\u6027<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u5de5\u4f5c\u51c6\u5219<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u7edf\u4e00\u5c42\u7ea7\uff08\u7981\u6b62\u6df7\u5c42\uff09<\/li><li>\u5b66\u79d1\u8282\u70b9\u547d\u540d\uff1a\u5b66\u6bb5+\u5b66\u79d1\uff08\u9ad8\u4e2d\u6570\u5b66\/\u521d\u4e2d\u9053\u5fb7\u4e0e\u6cd5\u6cbb\uff09<\/li><li>subject_name \u5168\u4e2d\u6587\u4e14\u6620\u5c04\u4e00\u81f4<\/li><li>\u6574\u5408\u540e\u5fc5\u987b\u8d28\u68c0\uff08\u91cd\u590d\/pid\/full_path\/\u8986\u76d6\uff09<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u6280\u672f\u80cc\u666f<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>\u8868<\/th><th>\u7528\u9014<\/th><\/tr><\/thead><tbody><tr><td>sq_catalog<\/td><td>\u6559\u6750\u76ee\u5f55\u6811<\/td><\/tr><tr><td>sq_knowledge<\/td><td>\u77e5\u8bc6\u70b9\u6811<\/td><\/tr><tr><td>sq_knowledge2<\/td><td>\u77e5\u8bc62\u6570\u636e\uff08\u6574\u5408\u6e90\uff09<\/td><\/tr><tr><td>sq_question_knowledge<\/td><td>\u9898\u76ee\u2194\u77e5\u8bc6\u70b9\u6620\u5c04<\/td><\/tr><tr><td>sq_catalog_knowledge<\/td><td>\u76ee\u5f55\u2194\u77e5\u8bc6\u70b9\u6620\u5c04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u4f7f\u7528\u793a\u4f8b<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># \u77e5\u8bc6\u70b9\u6574\u5408+\u6821\u9a8c\nD:\/BtSoft\/php\/80\/php.exe database\/export_sq_knowledge.php\nD:\/BtSoft\/php\/80\/php.exe database\/validate_sq_knowledge.php\n\n# \u6559\u6750\u76ee\u5f55\u5bfc\u51fa\/\u5bfc\u5165\nD:\/BtSoft\/php\/80\/php.exe database\/export_sq_catalog.php\nD:\/BtSoft\/php\/80\/php.exe database\/import_sq_catalog.php<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001edu-textbook-catalog \u2014 \u5c0f\u521d\u9ad8\u6559\u6750\u76ee\u5f55\u7ba1\u7406 \u6280\u80fd\u7b80\u4ecb\uff1a\u7ba1\u7406 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-806","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/posts\/806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/comments?post=806"}],"version-history":[{"count":0,"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/posts\/806\/revisions"}],"wp:attachment":[{"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/media?parent=806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/categories?post=806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/book.yuekegu.com\/index.php\/wp-json\/wp\/v2\/tags?post=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}