{"id":295,"date":"2026-01-25T01:58:29","date_gmt":"2026-01-24T17:58:29","guid":{"rendered":"https:\/\/skwp.zeabur.app\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9103-%e8%b3%87%e6%96%99%e8%a1%a8%e8%a8%ad%e8%a8%88%e8%88%87-crud-%e6%93%8d%e4%bd%9c%e5%af%a6%e6%88%b0\/"},"modified":"2026-01-25T01:58:29","modified_gmt":"2026-01-24T17:58:29","slug":"%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9103-%e8%b3%87%e6%96%99%e8%a1%a8%e8%a8%ad%e8%a8%88%e8%88%87-crud-%e6%93%8d%e4%bd%9c%e5%af%a6%e6%88%b0","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/01\/25\/%e3%80%90supabase-%e6%95%99%e5%ad%b8%e3%80%9103-%e8%b3%87%e6%96%99%e8%a1%a8%e8%a8%ad%e8%a8%88%e8%88%87-crud-%e6%93%8d%e4%bd%9c%e5%af%a6%e6%88%b0\/","title":{"rendered":"\u3010Supabase \u6559\u5b78\u3011#03 \u8cc7\u6599\u8868\u8a2d\u8a08\u8207 CRUD \u64cd\u4f5c\u5be6\u6230"},"content":{"rendered":"\n<div id=\"quiz-basic\">\n<style>\n#quiz-basic .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-basic .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-basic .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-basic .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-basic .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-basic .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-basic .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-basic .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-basic .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-basic .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-basic .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-basic .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-basic .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1aSupabase \u8cc7\u6599\u8868\u8a2d\u8a08\u8207 CRUD \u64cd\u4f5c\u5be6\u6230<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. \u5728 Supabase \u4e2d\u4f7f\u7528 <code>.insert()<\/code> \u65b0\u589e\u8cc7\u6599\u5f8c\uff0c\u5982\u679c\u60f3\u8981\u53d6\u5f97\u525b\u65b0\u589e\u7684\u8cc7\u6599\uff0c\u61c9\u8a72\u52a0\u4e0a\u4ec0\u9ebc\u65b9\u6cd5\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. <code>.returning()<\/code><\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. <code>.select()<\/code><\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. <code>.get()<\/code><\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. <code>.fetch()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u5728 Supabase \u67e5\u8a62\u4e2d\uff0c<code>.single()<\/code> \u65b9\u6cd5\u7684\u4f5c\u7528\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u53ea\u9078\u53d6\u4e00\u500b\u6b04\u4f4d<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u9650\u5236\u67e5\u8a62\u7d50\u679c\u6700\u591a\u4e00\u7b46<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u9810\u671f\u53ea\u6709\u4e00\u7b46\u7d50\u679c\uff0c\u76f4\u63a5\u56de\u50b3\u7269\u4ef6\u800c\u975e\u9663\u5217<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u5c07\u67e5\u8a62\u7d50\u679c\u5408\u4f75\u70ba\u55ae\u4e00\u5b57\u4e32<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u4ee5\u4e0b\u54ea\u500b\u904e\u6ffe\u65b9\u6cd5\u53ef\u4ee5\u7528\u4f86\u505a\u4e0d\u5340\u5206\u5927\u5c0f\u5beb\u7684\u6a21\u7cca\u641c\u5c0b\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'B')\">A. <code>.like()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'B')\">B. <code>.ilike()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'B')\">C. <code>.contains()<\/code><\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'B')\">D. <code>.match()<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u5728 Supabase \u4e2d\u8a2d\u5b9a\u95dc\u806f\u67e5\u8a62\u6642\uff0c\u82e5\u8981\u67e5\u8a62\u6587\u7ae0\u53ca\u5176\u6240\u6709\u7559\u8a00\uff0c\u6b63\u78ba\u7684 select \u8a9e\u6cd5\u662f\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'D')\">A. <code>.select('posts.*, comments.*')<\/code><\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'D')\">B. <code>.select('*').join('comments')<\/code><\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'D')\">C. <code>.select('* INNER JOIN comments')<\/code><\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'D')\">D. <code>.select('*, comments(*)')<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u5728\u9032\u884c <code>.update()<\/code> \u6216 <code>.delete()<\/code> \u64cd\u4f5c\u6642\uff0c\u5982\u679c\u6c92\u6709\u52a0\u4e0a\u904e\u6ffe\u689d\u4ef6\uff08\u5982 <code>.eq()<\/code>\uff09\uff0c\u6703\u767c\u751f\u4ec0\u9ebc\u4e8b\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'B')\">A. \u64cd\u4f5c\u6703\u5931\u6557\u4e26\u62cb\u51fa\u932f\u8aa4<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'B')\">B. \u6703\u5c0d\u6574\u500b\u8cc7\u6599\u8868\u7684\u6240\u6709\u8cc7\u6599\u57f7\u884c\u64cd\u4f5c<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'B')\">C. \u53ea\u6703\u5f71\u97ff\u7b2c\u4e00\u7b46\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'B')\">D. \u7cfb\u7d71\u6703\u81ea\u52d5\u8df3\u904e\uff0c\u4e0d\u57f7\u884c\u4efb\u4f55\u64cd\u4f5c<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"\u5728 Supabase \u4e2d\uff0c<code>.insert()<\/code> \u9810\u8a2d\u4e0d\u6703\u56de\u50b3\u65b0\u589e\u7684\u8cc7\u6599\uff08\u53ea\u56de\u50b3 null\uff09\u3002\u82e5\u8981\u53d6\u5f97\u525b\u63d2\u5165\u7684\u8cc7\u6599\uff0c\u5fc5\u9808\u5728\u5f8c\u9762\u52a0\u4e0a <code>.select()<\/code>\u3002\",\n        2: \"<code>.single()<\/code> \u6703\u8b93\u67e5\u8a62\u7d50\u679c\u76f4\u63a5\u56de\u50b3\u55ae\u4e00\u7269\u4ef6\uff0c\u800c\u975e\u5305\u5728\u9663\u5217\u4e2d\u3002\u5982\u679c\u67e5\u8a62\u7d50\u679c\u662f\u96f6\u7b46\u6216\u591a\u7b46\uff0c\u5247\u6703\u5831\u932f\u3002\u9019\u9069\u5408\u7528\u5728\u67e5\u8a62\u55ae\u4e00\u7b46\u8cc7\u6599\u7684\u60c5\u5883\uff0c\u4f8b\u5982\u900f\u904e id \u67e5\u8a62\u7279\u5b9a\u8a18\u9304\u3002\",\n        3: \"<code>.like()<\/code> \u662f\u5340\u5206\u5927\u5c0f\u5beb\u7684\u6a21\u7cca\u641c\u5c0b\uff0c\u800c <code>.ilike()<\/code> \u5247\u662f\u4e0d\u5340\u5206\u5927\u5c0f\u5beb\u7684\u7248\u672c\u3002\u5728 PostgreSQL \u4e2d\uff0cILIKE \u4ee3\u8868 case-Insensitive LIKE\u3002\",\n        4: \"Supabase \u7684\u95dc\u806f\u67e5\u8a62\u4f7f\u7528\u5de2\u72c0\u8a9e\u6cd5\u3002\u5728 <code>.select()<\/code> \u4e2d\u76f4\u63a5\u5beb <code>comments(*)<\/code> \u5c31\u53ef\u4ee5\u53d6\u5f97\u95dc\u806f\u7684\u7559\u8a00\u8cc7\u6599\u3002\u524d\u63d0\u662f\u5df2\u7d93\u8a2d\u5b9a\u597d Foreign Key \u95dc\u806f\u3002\",\n        5: \"\u9019\u662f\u975e\u5e38\u91cd\u8981\u7684\u5b89\u5168\u6ce8\u610f\u4e8b\u9805\uff01\u5982\u679c\u57f7\u884c <code>.update()<\/code> \u6216 <code>.delete()<\/code> \u6642\u6c92\u6709\u52a0\u4e0a\u904e\u6ffe\u689d\u4ef6\uff0cSupabase \u6703\u5c0d\u6574\u500b\u8cc7\u6599\u8868\u7684\u6240\u6709\u8cc7\u6599\u57f7\u884c\u64cd\u4f5c\uff0c\u53ef\u80fd\u5c0e\u81f4\u707d\u96e3\u6027\u7684\u5f8c\u679c\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" \ud83c\udf89 \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" \ud83d\udc4d \u4e0d\u932f\uff01\"\n                : \" \ud83d\udcda \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\u524d\u8a00<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u524d\u5169\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5df2\u7d93\u8a8d\u8b58\u4e86 Supabase \u4e26\u5b8c\u6210\u5c08\u6848\u5efa\u7acb\u8207\u74b0\u5883\u8a2d\u5b9a\u3002\u73fe\u5728\u662f\u6642\u5019\u958b\u59cb\u771f\u6b63\u64cd\u4f5c\u8cc7\u6599\u5eab\u4e86\u3002\u672c\u7bc7\u5c07\u5e36\u4f60\u5f9e\u5efa\u7acb\u8cc7\u6599\u8868\u958b\u59cb\uff0c\u4e00\u8def\u5b78\u6703\u5b8c\u6574\u7684 CRUD\uff08Create, Read, Update, Delete\uff09\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u7528 AI \u8f14\u52a9\u958b\u767c\u6642\uff0c\u770b\u5230 Supabase \u76f8\u95dc\u7a0b\u5f0f\u78bc\uff0c\u4f60\u6703\u77e5\u9053\u6bcf\u4e00\u884c\u5728\u505a\u4ec0\u9ebc\uff0c\u800c\u4e0d\u662f\u76f2\u76ee\u5730\u8907\u88fd\u8cbc\u4e0a\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b78\u7fd2\u76ee\u6a19<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u672c\u7bc7\u5f8c\uff0c\u4f60\u5c07\u80fd\u5920\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5728 Supabase \u4e2d\u8a2d\u8a08\u4e26\u5efa\u7acb\u8cc7\u6599\u8868<\/li>\n<li>\u4f7f\u7528 Supabase Client \u9032\u884c\u5b8c\u6574\u7684 CRUD \u64cd\u4f5c<\/li>\n<li>\u4e86\u89e3 Supabase \u67e5\u8a62\u8a9e\u6cd5\u8207\u904e\u6ffe\u689d\u4ef6<\/li>\n<li>\u8655\u7406\u8cc7\u6599\u95dc\u806f\u8207 JOIN \u67e5\u8a62<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u3001\u4f7f\u7528 Table Editor \u5efa\u7acb\u8cc7\u6599\u8868<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase \u63d0\u4f9b\u76f4\u89ba\u7684\u5716\u5f62\u5316\u4ecb\u9762\u8b93\u4f60\u5efa\u7acb\u8cc7\u6599\u8868\uff0c\u4e0d\u9700\u8981\u624b\u5beb SQL\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 \u9032\u5165 Table Editor<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u767b\u5165 Supabase Dashboard \u5f8c\uff0c\u5728\u5de6\u5074\u9078\u55ae\u9ede\u9078 <strong>Table Editor<\/strong>\uff0c\u4f60\u6703\u770b\u5230\u76ee\u524d\u5c08\u6848\u7684\u6240\u6709\u8cc7\u6599\u8868\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.2 \u5efa\u7acb\u7b2c\u4e00\u500b\u8cc7\u6599\u8868<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9ede\u9078 <strong>New Table<\/strong> \u6309\u9215\uff0c\u6703\u51fa\u73fe\u5efa\u7acb\u8868\u55ae\u3002\u4ee5\u5efa\u7acb\u4e00\u500b <code>posts<\/code>\uff08\u6587\u7ae0\uff09\u8cc7\u6599\u8868\u70ba\u4f8b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6b04\u4f4d\u540d\u7a31<\/th>\n<th>\u8cc7\u6599\u578b\u5225<\/th>\n<th>\u8aaa\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>id<\/td>\n<td>int8<\/td>\n<td>\u4e3b\u9375\uff0c\u81ea\u52d5\u905e\u589e<\/td>\n<\/tr>\n<tr>\n<td>title<\/td>\n<td>text<\/td>\n<td>\u6587\u7ae0\u6a19\u984c<\/td>\n<\/tr>\n<tr>\n<td>content<\/td>\n<td>text<\/td>\n<td>\u6587\u7ae0\u5167\u5bb9<\/td>\n<\/tr>\n<tr>\n<td>author_id<\/td>\n<td>uuid<\/td>\n<td>\u4f5c\u8005 ID\uff08\u95dc\u806f auth.users\uff09<\/td>\n<\/tr>\n<tr>\n<td>is_published<\/td>\n<td>bool<\/td>\n<td>\u662f\u5426\u5df2\u767c\u5e03<\/td>\n<\/tr>\n<tr>\n<td>view_count<\/td>\n<td>int4<\/td>\n<td>\u700f\u89bd\u6b21\u6578<\/td>\n<\/tr>\n<tr>\n<td>created_at<\/td>\n<td>timestamptz<\/td>\n<td>\u5efa\u7acb\u6642\u9593<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">1.3 \u5e38\u7528\u8cc7\u6599\u578b\u5225\u5c0d\u7167<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u5728 AI \u751f\u6210\u7684\u7a0b\u5f0f\u78bc\u4e2d\u770b\u5230\u9019\u4e9b\u578b\u5225\u6642\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">int2, int4, int8    \u2192 \u6574\u6578\uff08<span class=\"hljs-number\">2<\/span>\/<span class=\"hljs-number\">4<\/span>\/<span class=\"hljs-number\">8<\/span> bytes\uff09\nfloat4, float8      \u2192 \u6d6e\u9ede\u6578\ntext, varchar       \u2192 \u6587\u5b57\nbool                \u2192 \u5e03\u6797\u503c\nuuid                \u2192 \u901a\u7528\u552f\u4e00\u8b58\u5225\u78bc\ntimestamptz         \u2192 \u5e36\u6642\u5340\u7684\u6642\u9593\u6233\u8a18\njsonb               \u2192 <span class=\"hljs-built_in\">JSON<\/span> \u8cc7\u6599\uff08\u53ef\u67e5\u8a62\uff09\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">1.4 \u91cd\u8981\u7d04\u675f\u8a2d\u5b9a<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5efa\u7acb\u6b04\u4f4d\u6642\uff0c\u4f60\u6703\u770b\u5230\u9019\u4e9b\u9078\u9805\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Primary Key\uff08\u4e3b\u9375\uff09<\/strong>\uff1a\u552f\u4e00\u8b58\u5225\u6bcf\u4e00\u7b46\u8cc7\u6599<\/li>\n<li><strong>Is Nullable<\/strong>\uff1a\u662f\u5426\u5141\u8a31\u7a7a\u503c\uff08NULL\uff09<\/li>\n<li><strong>Is Unique<\/strong>\uff1a\u662f\u5426\u8981\u6c42\u503c\u4e0d\u91cd\u8907<\/li>\n<li><strong>Default Value<\/strong>\uff1a\u9810\u8a2d\u503c\uff0c\u4f8b\u5982 <code>now()<\/code> \u81ea\u52d5\u586b\u5165\u7576\u524d\u6642\u9593<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001Supabase Client \u521d\u59cb\u5316<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u9032\u884c CRUD \u64cd\u4f5c\u524d\uff0c\u9700\u8981\u5148\u521d\u59cb\u5316 Supabase Client\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.1 JavaScript\/TypeScript \u521d\u59cb\u5316<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">import<\/span> { createClient } <span class=\"hljs-keyword\">from<\/span> <span class=\"hljs-string\">'@supabase\/supabase-js'<\/span>\n\n<span class=\"hljs-keyword\">const<\/span> supabaseUrl = <span class=\"hljs-string\">'https:\/\/your-project.supabase.co'<\/span>\n<span class=\"hljs-keyword\">const<\/span> supabaseAnonKey = <span class=\"hljs-string\">'your-anon-key'<\/span>\n\n<span class=\"hljs-keyword\">const<\/span> supabase = createClient(supabaseUrl, supabaseAnonKey)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u770b\u5230\u9019\u6bb5\u7a0b\u5f0f\u78bc\u6642\uff0c\u7406\u89e3\u91cd\u9ede\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>supabaseUrl<\/code>\uff1a\u4f60\u7684\u5c08\u6848 API \u7aef\u9ede<\/li>\n<li><code>supabaseAnonKey<\/code>\uff1a\u516c\u958b\u7684\u533f\u540d\u91d1\u9470\uff08\u53ef\u4ee5\u653e\u5728\u524d\u7aef\uff09<\/li>\n<li><code>createClient<\/code>\uff1a\u5efa\u7acb\u9023\u7dda\u5be6\u4f8b\uff0c\u5f8c\u7e8c\u6240\u6709\u64cd\u4f5c\u90fd\u900f\u904e\u5b83<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">2.2 Python \u521d\u59cb\u5316<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">from<\/span> supabase <span class=\"hljs-keyword\">import<\/span> create_client\n\nurl = <span class=\"hljs-string\">\"https:\/\/your-project.supabase.co\"<\/span>\nkey = <span class=\"hljs-string\">\"your-anon-key\"<\/span>\n\nsupabase = create_client(url, key)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e09\u3001CRUD \u64cd\u4f5c\u8a73\u89e3<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">3.1 Create\uff1a\u65b0\u589e\u8cc7\u6599<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u65b0\u589e\u55ae\u7b46\u8cc7\u6599<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)           <span class=\"hljs-comment\">\/\/ \u6307\u5b9a\u8cc7\u6599\u8868<\/span>\n  .insert({                <span class=\"hljs-comment\">\/\/ \u63d2\u5165\u7684\u8cc7\u6599\u7269\u4ef6<\/span>\n    <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u6211\u7684\u7b2c\u4e00\u7bc7\u6587\u7ae0'<\/span>,\n    <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u9019\u662f\u5167\u5bb9...'<\/span>,\n    <span class=\"hljs-attr\">is_published<\/span>: <span class=\"hljs-literal\">true<\/span>\n  })\n  .select()                <span class=\"hljs-comment\">\/\/ \u56de\u50b3\u65b0\u589e\u7684\u8cc7\u6599<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9010\u884c\u89e3\u8b80\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>.from('posts')<\/code>\uff1a\u9078\u64c7\u8981\u64cd\u4f5c\u7684\u8cc7\u6599\u8868<\/li>\n<li><code>.insert({...})<\/code>\uff1a\u50b3\u5165\u8981\u65b0\u589e\u7684\u8cc7\u6599\u7269\u4ef6<\/li>\n<li><code>.select()<\/code>\uff1a\u8b93\u56de\u50b3\u7d50\u679c\u5305\u542b\u65b0\u589e\u7684\u8cc7\u6599\uff08\u5426\u5247\u53ea\u56de\u50b3 null\uff09<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">\u65b0\u589e\u591a\u7b46\u8cc7\u6599<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .insert(&#91;\n    { <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u6587\u7ae0\u4e00'<\/span>, <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u5167\u5bb9\u4e00'<\/span> },\n    { <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u6587\u7ae0\u4e8c'<\/span>, <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u5167\u5bb9\u4e8c'<\/span> },\n    { <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u6587\u7ae0\u4e09'<\/span>, <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u5167\u5bb9\u4e09'<\/span> }\n  ])\n  .select()\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u50b3\u5165\u9663\u5217\u5373\u53ef\u6279\u6b21\u65b0\u589e\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.2 Read\uff1a\u67e5\u8a62\u8cc7\u6599<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">\u67e5\u8a62\u6240\u6709\u8cc7\u6599<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)  <span class=\"hljs-comment\">\/\/ * \u8868\u793a\u9078\u53d6\u6240\u6709\u6b04\u4f4d<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\">\u67e5\u8a62\u7279\u5b9a\u6b04\u4f4d<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'id, title, created_at'<\/span>)  <span class=\"hljs-comment\">\/\/ \u53ea\u53d6\u9700\u8981\u7684\u6b04\u4f4d<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6548\u80fd\u63d0\u793a\uff1a\u53ea\u9078\u53d6\u9700\u8981\u7684\u6b04\u4f4d\u53ef\u4ee5\u6e1b\u5c11\u50b3\u8f38\u91cf\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">\u67e5\u8a62\u55ae\u7b46\u8cc7\u6599<\/h4>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n  .eq(<span class=\"hljs-string\">'id'<\/span>, <span class=\"hljs-number\">1<\/span>)      <span class=\"hljs-comment\">\/\/ \u689d\u4ef6\uff1aid \u7b49\u65bc 1<\/span>\n  .single()         <span class=\"hljs-comment\">\/\/ \u9810\u671f\u53ea\u6709\u4e00\u7b46\u7d50\u679c<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>.single()<\/code> \u6703\u76f4\u63a5\u56de\u50b3\u7269\u4ef6\u800c\u975e\u9663\u5217\uff0c\u5982\u679c\u67e5\u5230\u591a\u7b46\u6216\u96f6\u7b46\u6703\u5831\u932f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.3 Update\uff1a\u66f4\u65b0\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .update({\n    <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u66f4\u65b0\u5f8c\u7684\u6a19\u984c'<\/span>,\n    <span class=\"hljs-attr\">is_published<\/span>: <span class=\"hljs-literal\">false<\/span>\n  })\n  .eq(<span class=\"hljs-string\">'id'<\/span>, <span class=\"hljs-number\">1<\/span>)      <span class=\"hljs-comment\">\/\/ \u91cd\u8981\uff1a\u6307\u5b9a\u8981\u66f4\u65b0\u54ea\u4e00\u7b46<\/span>\n  .select()\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u6ce8\u610f\uff1a\u5982\u679c\u6c92\u6709\u52a0\u4e0a\u904e\u6ffe\u689d\u4ef6\uff08\u5982 <code>.eq()<\/code>\uff09\uff0c\u6703\u66f4\u65b0\u6574\u500b\u8cc7\u6599\u8868\u7684\u6240\u6709\u8cc7\u6599\uff01<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.4 Delete\uff1a\u522a\u9664\u8cc7\u6599<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .delete()\n  .eq(<span class=\"hljs-string\">'id'<\/span>, <span class=\"hljs-number\">1<\/span>)      <span class=\"hljs-comment\">\/\/ \u91cd\u8981\uff1a\u6307\u5b9a\u8981\u522a\u9664\u54ea\u4e00\u7b46<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u540c\u6a23\u5730\uff0c\u6c92\u6709\u904e\u6ffe\u689d\u4ef6\u6703\u522a\u9664\u6240\u6709\u8cc7\u6599\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u56db\u3001\u67e5\u8a62\u904e\u6ffe\u689d\u4ef6<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Supabase \u63d0\u4f9b\u8c50\u5bcc\u7684\u904e\u6ffe\u65b9\u6cd5\uff0c\u8b93\u4f60\u7cbe\u78ba\u67e5\u8a62\u8cc7\u6599\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.1 \u6bd4\u8f03\u904b\u7b97\u5b50<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-11\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u7b49\u65bc<\/span>\n.eq(<span class=\"hljs-string\">'status'<\/span>, <span class=\"hljs-string\">'active'<\/span>)        <span class=\"hljs-comment\">\/\/ status = 'active'<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u4e0d\u7b49\u65bc<\/span>\n.neq(<span class=\"hljs-string\">'status'<\/span>, <span class=\"hljs-string\">'deleted'<\/span>)      <span class=\"hljs-comment\">\/\/ status != 'deleted'<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u5927\u65bc<\/span>\n.gt(<span class=\"hljs-string\">'view_count'<\/span>, <span class=\"hljs-number\">100<\/span>)         <span class=\"hljs-comment\">\/\/ view_count &gt; 100<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u5927\u65bc\u7b49\u65bc<\/span>\n.gte(<span class=\"hljs-string\">'view_count'<\/span>, <span class=\"hljs-number\">100<\/span>)        <span class=\"hljs-comment\">\/\/ view_count &gt;= 100<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u5c0f\u65bc<\/span>\n.lt(<span class=\"hljs-string\">'view_count'<\/span>, <span class=\"hljs-number\">50<\/span>)          <span class=\"hljs-comment\">\/\/ view_count &lt; 50<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u5c0f\u65bc\u7b49\u65bc<\/span>\n.lte(<span class=\"hljs-string\">'view_count'<\/span>, <span class=\"hljs-number\">50<\/span>)         <span class=\"hljs-comment\">\/\/ view_count &lt;= 50<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-11\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">4.2 \u6587\u5b57\u641c\u5c0b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-12\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\">\/\/ \u6a21\u7cca\u641c\u5c0b\uff08\u5340\u5206\u5927\u5c0f\u5beb\uff09<\/span>\n.like(<span class=\"hljs-string\">'title'<\/span>, <span class=\"hljs-string\">'%\u6559\u5b78%'<\/span>)       <span class=\"hljs-comment\">\/\/ title LIKE '%\u6559\u5b78%'<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u6a21\u7cca\u641c\u5c0b\uff08\u4e0d\u5340\u5206\u5927\u5c0f\u5beb\uff09<\/span>\n.ilike(<span class=\"hljs-string\">'title'<\/span>, <span class=\"hljs-string\">'%tutorial%'<\/span>)  <span class=\"hljs-comment\">\/\/ title ILIKE '%tutorial%'<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-12\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>%<\/code> \u662f\u842c\u7528\u5b57\u5143\uff0c\u4ee3\u8868\u4efb\u610f\u5b57\u5143\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.3 \u9663\u5217\u8207\u7bc4\u570d<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-13\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u5728\u6307\u5b9a\u503c\u4e2d<\/span>\n.in(<span class=\"hljs-string\">'status'<\/span>, &#91;<span class=\"hljs-string\">'draft'<\/span>, <span class=\"hljs-string\">'review'<\/span>])  <span class=\"hljs-comment\">\/\/ status IN ('draft', 'review')<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u5305\u542b\uff08\u9663\u5217\u6b04\u4f4d\uff09<\/span>\n.contains(<span class=\"hljs-string\">'tags'<\/span>, &#91;<span class=\"hljs-string\">'javascript'<\/span>])   <span class=\"hljs-comment\">\/\/ tags \u9663\u5217\u5305\u542b 'javascript'<\/span>\n\n<span class=\"hljs-comment\">\/\/ \u7bc4\u570d\u67e5\u8a62<\/span>\n.gte(<span class=\"hljs-string\">'created_at'<\/span>, <span class=\"hljs-string\">'2024-01-01'<\/span>)\n.lt(<span class=\"hljs-string\">'created_at'<\/span>, <span class=\"hljs-string\">'2024-02-01'<\/span>)     <span class=\"hljs-comment\">\/\/ \u67e5\u8a62\u4e00\u6708\u4efd\u7684\u8cc7\u6599<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-13\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">4.4 \u7d44\u5408\u591a\u500b\u689d\u4ef6<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-14\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n  .eq(<span class=\"hljs-string\">'is_published'<\/span>, <span class=\"hljs-literal\">true<\/span>)\n  .gt(<span class=\"hljs-string\">'view_count'<\/span>, <span class=\"hljs-number\">100<\/span>)\n  .order(<span class=\"hljs-string\">'created_at'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-14\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u591a\u500b\u904e\u6ffe\u689d\u4ef6\u6703\u4ee5 AND \u908f\u8f2f\u7d44\u5408\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.5 OR \u689d\u4ef6<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-15\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n  .or(<span class=\"hljs-string\">'status.eq.draft,status.eq.review'<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-15\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4f7f\u7528 <code>.or()<\/code> \u6642\uff0c\u689d\u4ef6\u683c\u5f0f\u662f <code>\u6b04\u4f4d.\u904b\u7b97\u5b50.\u503c<\/code>\uff0c\u7528\u9017\u865f\u5206\u9694\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e94\u3001\u6392\u5e8f\u8207\u5206\u9801<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">5.1 \u6392\u5e8f (order)<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-16\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u4f9d\u5efa\u7acb\u6642\u9593\u964d\u5e8f\u6392\u5217\uff08\u6700\u65b0\u7684\u5728\u524d\uff09<\/span>\n.order(<span class=\"hljs-string\">'created_at'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n\n<span class=\"hljs-comment\">\/\/ \u591a\u6b04\u4f4d\u6392\u5e8f<\/span>\n.order(<span class=\"hljs-string\">'is_published'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n.order(<span class=\"hljs-string\">'created_at'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-16\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">5.2 \u9650\u5236\u7b46\u6578 (limit)<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-17\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u53ea\u53d6\u524d 10 \u7b46<\/span>\n.limit(<span class=\"hljs-number\">10<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-17\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">5.3 \u5206\u9801 (range)<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-18\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u53d6\u7b2c 11-20 \u7b46\uff08\u5f9e 0 \u958b\u59cb\u7b97\uff09<\/span>\n.range(<span class=\"hljs-number\">10<\/span>, <span class=\"hljs-number\">19<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-18\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">5.4 \u5b8c\u6574\u5206\u9801\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-19\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> page = <span class=\"hljs-number\">2<\/span>          <span class=\"hljs-comment\">\/\/ \u7b2c\u5e7e\u9801\uff08\u5f9e 1 \u958b\u59cb\uff09<\/span>\n<span class=\"hljs-keyword\">const<\/span> pageSize = <span class=\"hljs-number\">10<\/span>     <span class=\"hljs-comment\">\/\/ \u6bcf\u9801\u7b46\u6578<\/span>\n<span class=\"hljs-keyword\">const<\/span> <span class=\"hljs-keyword\">from<\/span> = (page - <span class=\"hljs-number\">1<\/span>) * pageSize\n<span class=\"hljs-keyword\">const<\/span> to = <span class=\"hljs-keyword\">from<\/span> + pageSize - <span class=\"hljs-number\">1<\/span>\n\n<span class=\"hljs-keyword\">const<\/span> { data, error, count } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>, { <span class=\"hljs-attr\">count<\/span>: <span class=\"hljs-string\">'exact'<\/span> })  <span class=\"hljs-comment\">\/\/ \u540c\u6642\u53d6\u5f97\u7e3d\u7b46\u6578<\/span>\n  .order(<span class=\"hljs-string\">'created_at'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n  .range(<span class=\"hljs-keyword\">from<\/span>, to)\n\n<span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">`\u7e3d\u5171 <span class=\"hljs-subst\">${count}<\/span> \u7b46\uff0c\u986f\u793a\u7b2c <span class=\"hljs-subst\">${<span class=\"hljs-keyword\">from<\/span> + <span class=\"hljs-number\">1<\/span>}<\/span> \u5230 <span class=\"hljs-subst\">${to + <span class=\"hljs-number\">1<\/span>}<\/span> \u7b46`<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-19\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>{ count: 'exact' }<\/code> \u6703\u984d\u5916\u56de\u50b3\u7b26\u5408\u689d\u4ef6\u7684\u7e3d\u7b46\u6578\uff0c\u65b9\u4fbf\u8a08\u7b97\u7e3d\u9801\u6578\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u516d\u3001\u95dc\u806f\u67e5\u8a62<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">6.1 \u8a2d\u5b9a Foreign Key<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728 Table Editor \u4e2d\u5efa\u7acb <code>comments<\/code> \u8cc7\u6599\u8868\u6642\uff0c\u8a2d\u5b9a <code>post_id<\/code> \u6b04\u4f4d\u95dc\u806f\u5230 <code>posts.id<\/code>\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u5efa\u7acb <code>post_id<\/code> \u6b04\u4f4d\uff08\u578b\u5225 int8\uff09<\/li>\n<li>\u9ede\u9078\u6b04\u4f4d\u65c1\u7684\u9023\u7d50\u5716\u793a<\/li>\n<li>\u9078\u64c7 Foreign Key \u95dc\u806f\u5230 <code>posts<\/code> \u8868\u7684 <code>id<\/code> \u6b04\u4f4d<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">6.2 \u67e5\u8a62\u95dc\u806f\u8cc7\u6599<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a2d\u5b9a\u597d Foreign Key \u5f8c\uff0c\u53ef\u4ee5\u7528\u5de2\u72c0\u8a9e\u6cd5\u4e00\u6b21\u67e5\u8a62\u95dc\u806f\u8cc7\u6599\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-20\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u67e5\u8a62\u6587\u7ae0\uff0c\u540c\u6642\u53d6\u5f97\u8a72\u6587\u7ae0\u7684\u6240\u6709\u7559\u8a00<\/span>\n<span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">`\n    id,\n    title,\n    comments (\n      id,\n      content,\n      created_at\n    )\n  `<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-20\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u56de\u50b3\u7d50\u69cb\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-21\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">&#91;\n  {\n    <span class=\"hljs-attr\">id<\/span>: <span class=\"hljs-number\">1<\/span>,\n    <span class=\"hljs-attr\">title<\/span>: <span class=\"hljs-string\">'\u6211\u7684\u7b2c\u4e00\u7bc7\u6587\u7ae0'<\/span>,\n    <span class=\"hljs-attr\">comments<\/span>: &#91;\n      { <span class=\"hljs-attr\">id<\/span>: <span class=\"hljs-number\">1<\/span>, <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u597d\u6587\u7ae0\uff01'<\/span>, <span class=\"hljs-attr\">created_at<\/span>: <span class=\"hljs-string\">'...'<\/span> },\n      { <span class=\"hljs-attr\">id<\/span>: <span class=\"hljs-number\">2<\/span>, <span class=\"hljs-attr\">content<\/span>: <span class=\"hljs-string\">'\u5b78\u5230\u5f88\u591a'<\/span>, <span class=\"hljs-attr\">created_at<\/span>: <span class=\"hljs-string\">'...'<\/span> }\n    ]\n  }\n]\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-21\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">6.3 \u53cd\u5411\u67e5\u8a62<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5f9e comments \u67e5\u8a62\u5c0d\u61c9\u7684 posts\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-22\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'comments'<\/span>)\n  .select(<span class=\"hljs-string\">`\n    id,\n    content,\n    posts (\n      id,\n      title\n    )\n  `<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-22\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">6.4 \u591a\u5c64\u95dc\u806f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5047\u8a2d\u9084\u6709 <code>users<\/code> \u8cc7\u6599\u8868\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-23\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">`\n    id,\n    title,\n    users!author_id (\n      id,\n      name\n    ),\n    comments (\n      id,\n      content,\n      users (\n        id,\n        name\n      )\n    )\n  `<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-23\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><code>users!author_id<\/code> \u8a9e\u6cd5\u6307\u5b9a\u4f7f\u7528 <code>author_id<\/code> \u9019\u500b Foreign Key \u95dc\u806f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e03\u3001\u932f\u8aa4\u8655\u7406<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u6bcf\u500b\u64cd\u4f5c\u90fd\u6703\u56de\u50b3 <code>error<\/code> \u7269\u4ef6\uff0c\u52d9\u5fc5\u6aa2\u67e5\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-24\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-keyword\">const<\/span> { data, error } = <span class=\"hljs-keyword\">await<\/span> supabase\n  .from(<span class=\"hljs-string\">'posts'<\/span>)\n  .select(<span class=\"hljs-string\">'*'<\/span>)\n\n<span class=\"hljs-keyword\">if<\/span> (error) {\n  <span class=\"hljs-built_in\">console<\/span>.error(<span class=\"hljs-string\">'\u67e5\u8a62\u5931\u6557:'<\/span>, error.message)\n  <span class=\"hljs-comment\">\/\/ error.code \u5305\u542b\u932f\u8aa4\u4ee3\u78bc<\/span>\n  <span class=\"hljs-comment\">\/\/ error.details \u5305\u542b\u8a73\u7d30\u8cc7\u8a0a<\/span>\n  <span class=\"hljs-keyword\">return<\/span>\n}\n\n<span class=\"hljs-comment\">\/\/ \u6210\u529f\uff0c\u4f7f\u7528 data<\/span>\n<span class=\"hljs-built_in\">console<\/span>.log(<span class=\"hljs-string\">'\u67e5\u8a62\u7d50\u679c:'<\/span>, data)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-24\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5e38\u898b\u932f\u8aa4\u4ee3\u78bc\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>PGRST116<\/code>\uff1a\u67e5\u8a62\u7d50\u679c\u70ba\u7a7a\uff08\u4f7f\u7528 <code>.single()<\/code> \u6642\uff09<\/li>\n<li><code>23505<\/code>\uff1a\u9055\u53cd\u552f\u4e00\u7d04\u675f\uff08\u91cd\u8907\u8cc7\u6599\uff09<\/li>\n<li><code>23503<\/code>\uff1a\u9055\u53cd Foreign Key \u7d04\u675f<\/li>\n<li><code>42P01<\/code>\uff1a\u8cc7\u6599\u8868\u4e0d\u5b58\u5728<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u516b\u3001\u5be6\u6230\u5c0f\u7d50<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u5feb\u901f\u53c3\u8003\u8868<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u64cd\u4f5c<\/th>\n<th>\u65b9\u6cd5<\/th>\n<th>\u7bc4\u4f8b<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u65b0\u589e<\/td>\n<td><code>.insert()<\/code><\/td>\n<td><code>.insert({ title: '...' }).select()<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u67e5\u8a62<\/td>\n<td><code>.select()<\/code><\/td>\n<td><code>.select('id, title')<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u66f4\u65b0<\/td>\n<td><code>.update()<\/code><\/td>\n<td><code>.update({ title: '...' }).eq('id', 1)<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u522a\u9664<\/td>\n<td><code>.delete()<\/code><\/td>\n<td><code>.delete().eq('id', 1)<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u904e\u6ffe<\/td>\n<td><code>.eq()<\/code> <code>.gt()<\/code> <code>.like()<\/code><\/td>\n<td><code>.eq('status', 'active')<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u6392\u5e8f<\/td>\n<td><code>.order()<\/code><\/td>\n<td><code>.order('created_at', { ascending: false })<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u5206\u9801<\/td>\n<td><code>.range()<\/code> <code>.limit()<\/code><\/td>\n<td><code>.range(0, 9)<\/code><\/td>\n<\/tr>\n<tr>\n<td>\u95dc\u806f<\/td>\n<td>\u5de2\u72c0 select<\/td>\n<td><code>.select('*, comments(*)')<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u5e38\u898b\u6a21\u5f0f<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-25\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\"><span class=\"hljs-comment\">\/\/ \u53d6\u5f97\u5206\u9801\u5217\u8868<\/span>\n<span class=\"hljs-keyword\">const<\/span> getPostList = <span class=\"hljs-keyword\">async<\/span> (page, pageSize) =&gt; {\n  <span class=\"hljs-keyword\">const<\/span> <span class=\"hljs-keyword\">from<\/span> = (page - <span class=\"hljs-number\">1<\/span>) * pageSize\n  <span class=\"hljs-keyword\">const<\/span> to = <span class=\"hljs-keyword\">from<\/span> + pageSize - <span class=\"hljs-number\">1<\/span>\n\n  <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-keyword\">await<\/span> supabase\n    .from(<span class=\"hljs-string\">'posts'<\/span>)\n    .select(<span class=\"hljs-string\">'id, title, created_at'<\/span>, { <span class=\"hljs-attr\">count<\/span>: <span class=\"hljs-string\">'exact'<\/span> })\n    .eq(<span class=\"hljs-string\">'is_published'<\/span>, <span class=\"hljs-literal\">true<\/span>)\n    .order(<span class=\"hljs-string\">'created_at'<\/span>, { <span class=\"hljs-attr\">ascending<\/span>: <span class=\"hljs-literal\">false<\/span> })\n    .range(<span class=\"hljs-keyword\">from<\/span>, to)\n}\n\n<span class=\"hljs-comment\">\/\/ \u53d6\u5f97\u55ae\u7bc7\u6587\u7ae0\uff08\u542b\u7559\u8a00\uff09<\/span>\n<span class=\"hljs-keyword\">const<\/span> getPostDetail = <span class=\"hljs-keyword\">async<\/span> (id) =&gt; {\n  <span class=\"hljs-keyword\">return<\/span> <span class=\"hljs-keyword\">await<\/span> supabase\n    .from(<span class=\"hljs-string\">'posts'<\/span>)\n    .select(<span class=\"hljs-string\">`\n      *,\n      comments (\n        id, content, created_at,\n        users (id, name)\n      )\n    `<\/span>)\n    .eq(<span class=\"hljs-string\">'id'<\/span>, id)\n    .single()\n}\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-25\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u7d50\u8a9e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u5728\u4f60\u5df2\u7d93\u638c\u63e1\u4e86 Supabase \u7684\u8cc7\u6599\u8868\u8a2d\u8a08\u8207 CRUD \u64cd\u4f5c\u3002\u9019\u4e9b\u662f\u8207\u8cc7\u6599\u5eab\u4e92\u52d5\u7684\u57fa\u672c\u529f\uff0c\u7121\u8ad6\u4f60\u7528\u4ec0\u9ebc\u6846\u67b6\uff0c\u9019\u4e9b\u6982\u5ff5\u90fd\u901a\u7528\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0b\u4e00\u7bc7\u6211\u5011\u5c07\u6df1\u5165\u63a2\u8a0e Row Level Security\uff08RLS\uff09\uff0c\u5b78\u7fd2\u5982\u4f55\u4fdd\u8b77\u4f60\u7684\u8cc7\u6599\u5b89\u5168\uff0c\u78ba\u4fdd\u4f7f\u7528\u8005\u53ea\u80fd\u5b58\u53d6\u4ed6\u5011\u88ab\u6388\u6b0a\u7684\u8cc7\u6599\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u5ef6\u4f38\u95b1\u8b80<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/supabase.com\/docs\/guides\/database\">Supabase \u5b98\u65b9\u6587\u4ef6\uff1aDatabase<\/a><\/li>\n<li><a href=\"https:\/\/supabase.com\/docs\/reference\/javascript\">Supabase \u5b98\u65b9\u6587\u4ef6\uff1aJavaScript Client<\/a><\/li>\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/datatype.html\">PostgreSQL \u8cc7\u6599\u578b\u5225\u53c3\u8003<\/a><\/li>\n<\/ul>\n\n\n\n<div id=\"quiz-advanced\">\n<style>\n#quiz-advanced .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-advanced .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-advanced .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-advanced .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-advanced .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-advanced .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-advanced .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-advanced .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-advanced .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-advanced .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-advanced .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-advanced .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-advanced .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-advanced .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-advanced .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-advanced .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-advanced .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1aSupabase \u8cc7\u6599\u8868\u8a2d\u8a08\u8207 CRUD \u64cd\u4f5c\u5be6\u6230<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u6240\u5b78\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u6b63\u5728\u958b\u767c\u4e00\u500b\u90e8\u843d\u683c\u7cfb\u7d71\uff0c\u9700\u8981\u5be6\u4f5c\u6587\u7ae0\u5217\u8868\u9801\u9762\u7684\u5206\u9801\u529f\u80fd\u3002\u6bcf\u9801\u986f\u793a 10 \u7bc7\u6587\u7ae0\uff0c\u4f7f\u7528\u8005\u76ee\u524d\u5728\u7b2c 3 \u9801\u3002\u4f60\u61c9\u8a72\u5982\u4f55\u8a2d\u5b9a range \u53c3\u6578\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">const page = 3\nconst pageSize = 10\n\/\/ \u8a08\u7b97 range \u53c3\u6578&#8230;<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'C')\">A. <code>.range(3, 12)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'C')\">B. <code>.range(30, 39)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'C')\">C. <code>.range(20, 29)<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'C')\">D. <code>.range(21, 30)<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u4f60\u9700\u8981\u67e5\u8a62\u6240\u6709\u5df2\u767c\u5e03\u4e14\u700f\u89bd\u6b21\u6578\u8d85\u904e 100 \u7684\u6587\u7ae0\uff0c\u4e26\u6309\u5efa\u7acb\u6642\u9593\u5f9e\u65b0\u5230\u820a\u6392\u5e8f\u3002\u4ee5\u4e0b\u54ea\u500b\u5beb\u6cd5\u6700\u6b63\u78ba\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'B')\">A. <code>.select('*').eq('is_published', true).gt('view_count', 100).order('created_at')<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'B')\">B. <code>.select('*').eq('is_published', true).gt('view_count', 100).order('created_at', { ascending: false })<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'B')\">C. <code>.select('*').or('is_published.eq.true,view_count.gt.100').order('created_at', { ascending: false })<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'B')\">D. <code>.select('*').filter('is_published = true AND view_count > 100').orderBy('created_at DESC')<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 3 -->\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u60f3\u8981\u67e5\u8a62\u4e00\u7bc7\u6587\u7ae0\u7684\u8a73\u7d30\u8cc7\u8a0a\uff0c\u5305\u542b\u8a72\u6587\u7ae0\u7684\u6240\u6709\u7559\u8a00\uff0c\u4ee5\u53ca\u6bcf\u5247\u7559\u8a00\u7684\u4f5c\u8005\u8cc7\u8a0a\u3002\u5047\u8a2d comments \u8868\u6709 user_id \u6b04\u4f4d\u95dc\u806f\u5230 users \u8868\u3002\u4ee5\u4e0b\u54ea\u500b select \u8a9e\u6cd5\u6700\u9069\u5408\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. <code>.select('*, comments, users')<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. <code>.select('*').join('comments').join('users')<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. <code>.select('*, comments(*), comments.users(*)')<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. <code>.select('*, comments(*, users(*))')<\/code><\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5c0f\u660e\u4f7f\u7528\u4ee5\u4e0b\u7a0b\u5f0f\u78bc\u67e5\u8a62\u55ae\u4e00\u6587\u7ae0\uff0c\u4f46\u57f7\u884c\u5f8c\u767c\u751f\u932f\u8aa4\u3002\u6700\u53ef\u80fd\u7684\u539f\u56e0\u662f\u4ec0\u9ebc\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">const { data, error } = await supabase\n  .from(&#8216;posts&#8217;)\n  .select(&#8216;*&#8217;)\n  .eq(&#8216;slug&#8217;, &#8216;my-first-post&#8217;)\n  .single()\n\n\/\/ error: { code: &#8216;PGRST116&#8217;, message: &#8216;&#8230;&#8217; }<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. <code>slug<\/code> \u6b04\u4f4d\u4e0d\u5b58\u5728\u65bc\u8cc7\u6599\u8868\u4e2d<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u67e5\u8a62\u7d50\u679c\u70ba\u7a7a\uff08\u6c92\u6709\u627e\u5230\u7b26\u5408\u689d\u4ef6\u7684\u8cc7\u6599\uff09<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. <code>.single()<\/code> \u4e0d\u80fd\u8207 <code>.eq()<\/code> \u4e00\u8d77\u4f7f\u7528<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. \u7f3a\u5c11 <code>.from()<\/code> \u4e4b\u524d\u7684 await<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u5c0f\u83ef\u60f3\u8981\u66f4\u65b0\u7279\u5b9a\u6587\u7ae0\u7684\u6a19\u984c\uff0c\u4f46\u57f7\u884c\u5f8c\u767c\u73fe\u6240\u6709\u6587\u7ae0\u7684\u6a19\u984c\u90fd\u88ab\u6539\u6389\u4e86\u3002\u8acb\u554f\u7a0b\u5f0f\u78bc\u54ea\u88e1\u51fa\u4e86\u554f\u984c\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">const { data, error } = await supabase\n  .from(&#8216;posts&#8217;)\n  .update({ title: &#8216;\u65b0\u6a19\u984c&#8217; })\n  .select()\n\n\/\/ \u9810\u671f\u53ea\u66f4\u65b0 id=5 \u7684\u6587\u7ae0\uff0c\u4f46\u6240\u6709\u6587\u7ae0\u90fd\u88ab\u66f4\u65b0\u4e86<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. <code>.select()<\/code> \u61c9\u8a72\u653e\u5728 <code>.update()<\/code> \u4e4b\u524d<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u61c9\u8a72\u4f7f\u7528 <code>.updateOne()<\/code> \u800c\u975e <code>.update()<\/code><\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u7f3a\u5c11\u904e\u6ffe\u689d\u4ef6\uff08\u5982 <code>.eq('id', 5)<\/code>\uff09\u4f86\u6307\u5b9a\u8981\u66f4\u65b0\u54ea\u7b46\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. <code>.update()<\/code> \u7684\u53c3\u6578\u683c\u5f0f\u932f\u8aa4\uff0c\u61c9\u8a72\u7528\u9663\u5217<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"Supabase \u7684 <code>.range()<\/code> \u662f\u5f9e 0 \u958b\u59cb\u8a08\u7b97\u7d22\u5f15\u3002\u7b2c 3 \u9801\u7684\u8a08\u7b97\u65b9\u5f0f\uff1afrom = (3-1) * 10 = 20\uff0cto = 20 + 10 - 1 = 29\u3002\u6240\u4ee5\u6b63\u78ba\u7b54\u6848\u662f <code>.range(20, 29)<\/code>\uff0c\u6703\u53d6\u5f97\u7b2c 21 \u5230 30 \u7b46\u8cc7\u6599\uff08\u7d22\u5f15 20-29\uff09\u3002\",\n        2: \"\u591a\u500b\u904e\u6ffe\u689d\u4ef6\u6703\u4ee5 AND \u908f\u8f2f\u7d44\u5408\uff0c\u6240\u4ee5\u9023\u7e8c\u4f7f\u7528 <code>.eq()<\/code> \u548c <code>.gt()<\/code> \u662f\u6b63\u78ba\u7684\u3002\u6392\u5e8f\u4f7f\u7528 <code>.order()<\/code>\uff0c\u8981\u6307\u5b9a <code>{ ascending: false }<\/code> \u624d\u80fd\u5f9e\u65b0\u5230\u820a\u3002\u9078\u9805 A \u7f3a\u5c11\u6392\u5e8f\u65b9\u5411\u8a2d\u5b9a\uff08\u9810\u8a2d\u662f\u5347\u5e8f\uff09\uff0c\u9078\u9805 C \u4f7f\u7528 OR \u908f\u8f2f\u6703\u67e5\u5230\u4e0d\u7b26\u5408\u7684\u8cc7\u6599\uff0c\u9078\u9805 D \u7684\u8a9e\u6cd5\u4e0d\u662f Supabase \u652f\u63f4\u7684\u5beb\u6cd5\u3002\",\n        3: \"Supabase \u7684\u95dc\u806f\u67e5\u8a62\u4f7f\u7528\u5de2\u72c0\u8a9e\u6cd5\u3002\u8981\u67e5\u8a62\u6587\u7ae0\u7684\u7559\u8a00\uff0c\u518d\u67e5\u8a62\u6bcf\u5247\u7559\u8a00\u7684\u4f5c\u8005\uff0c\u6b63\u78ba\u5beb\u6cd5\u662f <code>comments(*, users(*))<\/code>\uff0c\u5c07 users \u5de2\u72c0\u5728 comments \u5167\u3002\u9019\u6a23\u6703\u81ea\u52d5\u900f\u904e Foreign Key \u95dc\u806f\u53d6\u5f97\u8cc7\u6599\u3002\",\n        4: \"\u932f\u8aa4\u4ee3\u78bc <code>PGRST116<\/code> \u8868\u793a\u67e5\u8a62\u7d50\u679c\u70ba\u7a7a\u3002\u7576\u4f7f\u7528 <code>.single()<\/code> \u6642\uff0c\u5982\u679c\u67e5\u8a62\u7d50\u679c\u662f\u96f6\u7b46\u6216\u591a\u7b46\u90fd\u6703\u5831\u932f\u3002\u5728\u9019\u500b\u60c5\u5883\u4e2d\uff0c\u6700\u53ef\u80fd\u662f\u8cc7\u6599\u5eab\u4e2d\u6c92\u6709 slug \u70ba 'my-first-post' \u7684\u6587\u7ae0\u3002\u89e3\u6c7a\u65b9\u6cd5\u662f\u5148\u78ba\u8a8d\u8cc7\u6599\u5b58\u5728\uff0c\u6216\u6539\u7528 <code>.maybeSingle()<\/code>\uff08\u4e0d\u6703\u5728\u96f6\u7b46\u6642\u5831\u932f\uff09\u3002\",\n        5: \"\u9019\u662f\u975e\u5e38\u5371\u96aa\u7684\u932f\u8aa4\uff01\u57f7\u884c <code>.update()<\/code> \u6642\u5982\u679c\u6c92\u6709\u52a0\u4e0a\u904e\u6ffe\u689d\u4ef6\uff08\u5982 <code>.eq('id', 5)<\/code>\uff09\uff0cSupabase \u6703\u66f4\u65b0\u6574\u500b\u8cc7\u6599\u8868\u7684\u6240\u6709\u8cc7\u6599\u3002\u6b63\u78ba\u5beb\u6cd5\u61c9\u8a72\u662f\uff1a<code>.update({ title: '\u65b0\u6a19\u984c' }).eq('id', 5).select()<\/code>\u3002\u540c\u6a23\u7684\u554f\u984c\u4e5f\u6703\u767c\u751f\u5728 <code>.delete()<\/code> \u64cd\u4f5c\u4e0a\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1aSupabase \u8cc7\u6599\u8868\u8a2d\u8a08\u8207 CRUD \u64cd\u4f5c\u5be6\u6230 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. \u5728 Su [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[197],"tags":[299,302,301,308],"class_list":["post-295","post","type-post","status-publish","format-standard","hentry","category-supabase","tag-crud","tag-postgresql","tag-supabase","tag-308"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}