{"id":5555,"date":"2026-08-14T13:38:48","date_gmt":"2026-08-14T04:38:48","guid":{"rendered":"https:\/\/batmask.net\/?p=5555"},"modified":"2026-08-14T13:39:41","modified_gmt":"2026-08-14T04:39:41","slug":"sqlite3-dot-commands","status":"publish","type":"post","link":"http:\/\/batmask.net\/index.php\/2026\/08\/14\/5555\/","title":{"rendered":"SQLite3 CLI .(dot) commands"},"content":{"rendered":"\n<p>SQLite\ub97c \uc0ac\uc6a9\ud560 \ub54c, SQL\ubb38\uc774 \uc544\ub2cc sqlite \ud504\ub86c\ud504\ud2b8 \uc258 \ub0b4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4\ub4e4\uc774 \uc788\ub2e4. CLT(Command Line Tool) \ub610\ub294 CLI(Command Line Interface)\ub77c\uace0 \ubd88\ub9b0\ub2e4. \ucd9c\ub825 \ud3ec\ub9f7\uc744 \ubcc0\uacbd\ud558\uac70\ub098, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc774 \ubb50\uac00 \uc788\ub294\uc9c0, \uc2a4\ud0a4\ub9c8\ub294 \uc5b4\ub5bb\uac8c \ub418\uc5b4 \uc788\ub294\uc9c0 \ub4f1\uc744 \ud655\uc778\ud558\ub294 \uc6a9\ub3c4\uc774\ub2e4. \uc2ec\uc9c0\uc5b4 export\ub3c4 \uc9c0\uc6d0\ud558\ub294\ub4f1 \uc0dd\uac01\ubcf4\ub2e4 \uae30\ub2a5\uc774 \ub9ce\uc740\ub370, \uac04\ub2e8\ud558\uac8c \uba87\uac00\uc9c0\ub9cc \uc54c\uc544\ubcf4\uc790.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">.help<\/h3>\n\n\n\n<p> \uae30\ubcf8\uc801\uc73c\ub85c &#8216;.&#8217;, dot\uc73c\ub85c \uc2dc\uc791\ud574\uc57c \ud55c\ub2e4. \uc774 \uc810\uc774 \ucee4\ub9e8\ub4dc\ub77c\uc778 \uba85\ub839\uc5b4\ub97c \uad6c\ubd84\uc9d3\ub294\ub2e4. &#8220;.help&#8221;\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubaa8\ub4e0 \uba85\ub839\uc5b4\ub97c \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> .help\n.archive ...             Manage SQL archives\n.auth ON|OFF             Show authorizer callbacks\n.backup ?DB? FILE        Backup DB (default \"main\") to FILE\n.bail on|off             Stop after hitting an error.  Default OFF\n.cd DIRECTORY            Change the working directory to DIRECTORY\n...<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">.help<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">.archive<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">...<\/span><span style=\"color: #ADBAC7\">             <\/span><span style=\"color: #96D0FF\">Manage<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">SQL<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">archives<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">.auth<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">ON<\/span><span style=\"color: #F47067\">|<\/span><span style=\"color: #F69D50\">OFF<\/span><span style=\"color: #ADBAC7\">             <\/span><span style=\"color: #96D0FF\">Show<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">authorizer<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">callbacks<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">.backup<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">?DB?<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">FILE<\/span><span style=\"color: #ADBAC7\">        <\/span><span style=\"color: #96D0FF\">Backup<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">DB<\/span><span style=\"color: #ADBAC7\"> (default <\/span><span style=\"color: #96D0FF\">&quot;main&quot;<\/span><span style=\"color: #ADBAC7\">) to FILE<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">.bail<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">on<\/span><span style=\"color: #F47067\">|<\/span><span style=\"color: #F69D50\">off<\/span><span style=\"color: #ADBAC7\">             <\/span><span style=\"color: #96D0FF\">Stop<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">after<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">hitting<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">an<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">error.<\/span><span style=\"color: #ADBAC7\">  <\/span><span style=\"color: #96D0FF\">Default<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">OFF<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">.cd<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">DIRECTORY<\/span><span style=\"color: #ADBAC7\">            <\/span><span style=\"color: #96D0FF\">Change<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">the<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">working<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">directory<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">to<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">DIRECTORY<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6CB6FF\">...<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">.quit<\/h3>\n\n\n\n<p>sqlite> \ucee4\ub9e8\ub4dc \ud504\ub86c\ud504\ud2b8\ub97c \uc885\ub8cc\ud558\ub294 \uba85\ub839\uc5b4\uc774\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">.open &lt;db><\/h3>\n\n\n\n<p> sqlite \ucee4\ub9e8\ub4dc \ud504\ub86c\ud504\ud2b8\ub97c \uc2e4\ud589\ud560 \ub54c\ub294 \ubcf4\ud1b5 db \ud30c\uc77c\uc744 \uc778\uc790\ub85c \uc8fc\uace0 \uc2dc\uc791\ud55c\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>~\/o\/sqlite  sqlite3 longlist.db                      1 \u2718 \u2502 18m 13s \u2502 12:59:04 \nSQLite version 3.45.1 2024-01-30 16:01:20\nEnter \".help\" for usage hints.\nsqlite> <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F47067\">~<\/span><span style=\"color: #ADBAC7\">\/o\/sqlite  sqlite3 longlist.db                      1 \u2718 \u2502 18m 13s \u2502 12:59:04 <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">SQLite<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">version<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">3.45<\/span><span style=\"color: #96D0FF\">.1<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">2024<\/span><span style=\"color: #96D0FF\">-01-30<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">16<\/span><span style=\"color: #96D0FF\">:01:20<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">Enter<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">&quot;.help&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">for<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">usage<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">hints.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\ud558\uc9c0\ub9cc, \ud30c\uc77c\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uace0 \ucee4\ub9e8\ub4dc \ud504\ub86c\ud504\ud2b8\ub97c \uc2e4\ud589\ud55c \uacbd\uc6b0, \ucee4\ub9e8\ub4dc \ud504\ub86c\ud504\ud2b8 \uc0c1\uc5d0\uc11c \ud30c\uc77c\uc744 open \ud560 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly> ~\/o\/sqlite  sqlite3                                     \u2714 \u2502 1m 25s \u2502 13:00:35 \nSQLite version 3.45.1 2024-01-30 16:01:20\nEnter \".help\" for usage hints.\nConnected to a transient in-memory database.\nUse \".open FILENAME\" to reopen on a persistent database.\nsqlite> .open longlist.db\nsqlite> <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #F69D50\">~\/o\/sqlite<\/span><span style=\"color: #ADBAC7\">  <\/span><span style=\"color: #96D0FF\">sqlite3<\/span><span style=\"color: #ADBAC7\">                                     <\/span><span style=\"color: #96D0FF\">\u2714<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">\u2502<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">1<\/span><span style=\"color: #96D0FF\">m<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">25<\/span><span style=\"color: #96D0FF\">s<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">\u2502<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">13<\/span><span style=\"color: #96D0FF\">:00:35<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">SQLite<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">version<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">3.45<\/span><span style=\"color: #96D0FF\">.1<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">2024<\/span><span style=\"color: #96D0FF\">-01-30<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #6CB6FF\">16<\/span><span style=\"color: #96D0FF\">:01:20<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">Enter<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">&quot;.help&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">for<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">usage<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">hints.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">Connected<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">to<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">a<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">transient<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">in-memory<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">database.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">Use<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">&quot;.open FILENAME&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">to<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">reopen<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">on<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">a<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">persistent<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">database.<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">.open<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">longlist.db<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>open \uc774 \uc788\uc73c\uba74 close\ub3c4 \uc788\uc744\uac70 \uac19\uc9c0\ub9cc, \ubcc4\ub3c4\ub85c close\ub294 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc0c8\ub85c\uc6b4 db\ud30c\uc77c\uc744 open\ud558\uba74 \uae30\uc874\uaebc\uac00 \ub2eb\ud788\uace0, \ub610\ub294 \uadf8\ub0e5 sqlite \ud504\ub86c\ud504\ud2b8\ub97c \uc885\ub8cc\ud558\uba74 \uadf8\ub9cc\uc774\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">.databases<\/h3>\n\n\n\n<p>\ud604\uc7ac open\ub41c database\uac00 \ubb54\uc9c0 \ud655\uc778\ud558\ub294 \uba85\ub839\uc5b4\uc774\ub2e4. <\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> .databases\nmain: \/home\/batmask\/Linux-500G\/output\/sqlite\/longlist.db r\/w\nsqlite> <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">.databases<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">main:<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">\/home\/batmask\/Linux-500G\/output\/sqlite\/longlist.db<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">r\/w<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">.tables<\/h3>\n\n\n\n<p> \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\ub4e4\uc744 \ud655\uc778\ud558\ub294 \uba85\ub839\uc5b4\uc774\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> .tables\nlonglist<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">.tables<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">longlist<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">.schema &lt;table><\/h3>\n\n\n\n<p> \ud2b9\uc815 \ud14c\uc774\ube14\uc758 \uc2a4\ud0a4\ub9c8\ub97c \ud655\uc778\ud558\ub294 \uba85\ub839\uc5b4\uc774\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(2 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Zsh<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> .schema longlist \nCREATE TABLE IF NOT EXISTS \"longlist\" (\n    \"isbn\" TEXT,\n    \"title\" TEXT,\n    \"author\" TEXT,\n    \"translator\" TEXT,\n    \"format\" TEXT,\n    \"pages\" INTEGER,\n    \"publisher\" TEXT,\n    \"published\" TEXT,\n    \"year\" INTEGER,\n    \"votes\" INTEGER,\n    \"rating\" REAL\n);\nsqlite> <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">.schema<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">longlist<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">CREATE<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TABLE<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">IF<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">NOT<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">EXISTS<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">&quot;longlist&quot;<\/span><span style=\"color: #ADBAC7\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;isbn&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;title&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;author&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;translator&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;format&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;pages&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">INTEGER,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;publisher&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;published&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">TEXT,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;year&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">INTEGER,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;votes&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">INTEGER,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">    <\/span><span style=\"color: #F69D50\">&quot;rating&quot;<\/span><span style=\"color: #ADBAC7\"> <\/span><span style=\"color: #96D0FF\">REAL<\/span><\/span>\n<span class=\"line\"><span style=\"color: #ADBAC7\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F69D50\">sqlite&gt;<\/span><span style=\"color: #ADBAC7\"> <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>table\uc744 \uc0dd\uc131\ud55c SQL \uc790\uccb4\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\ucd9c\ub825 \uacb0\uacfc \ub2e4\ub4ec\uae30 : .headers on, .mode column<\/h3>\n\n\n\n<p>\uae30\ubcf8\uc801\uc73c\ub85c SELECT\ub85c \uac00\uc838\uc624\ub294 \uacb0\uacfc\ubb3c\uc740 \ud5e4\ub354\ub3c4 \uc5c6\uace0 \uadf8\ub0e5 &#8216;|&#8217; \uad6c\ubd84\uc790\ub85c\ub9cc \uad6c\ubd84\ub418\uc5b4 \ucd9c\ub825\ub41c\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Plaintext<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> SELECT * FROM longlist LIMIT 5;\n9788439736967|Boulder|Eva Baltasar|Nicole d'Amonville Alegr\u00eda|paperback|112|Literatura Random House|2022-08-02|2023|2779|3.77\n9781628971538|Whale|Cheon Myeong-Kwan|Jae Won Chung|paperback|368|Europa Editions|2023-01-19|2023|175|3.97\n9781642861181|The Gospel According to the New World|Maryse Cond\u00e9|Richard Philcox|paperback|184|World Editions|2023-03-07|2023|114|3.05\n9781529414431|Standing Heavy|Gauz|Frank Wynne|paperback|252|MacLehose Press|2022-05-26|2023|322|3.57\n9781474623025|Time Shelter|Georgi Gospodinov|Angela Rodel|hardcover|304|W&amp;N|2022-04-21|2023|3142|4.05<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #adbac7\">sqlite&gt; SELECT * FROM longlist LIMIT 5;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9788439736967|Boulder|Eva Baltasar|Nicole d&#39;Amonville Alegr\u00eda|paperback|112|Literatura Random House|2022-08-02|2023|2779|3.77<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781628971538|Whale|Cheon Myeong-Kwan|Jae Won Chung|paperback|368|Europa Editions|2023-01-19|2023|175|3.97<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781642861181|The Gospel According to the New World|Maryse Cond\u00e9|Richard Philcox|paperback|184|World Editions|2023-03-07|2023|114|3.05<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781529414431|Standing Heavy|Gauz|Frank Wynne|paperback|252|MacLehose Press|2022-05-26|2023|322|3.57<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781474623025|Time Shelter|Georgi Gospodinov|Angela Rodel|hardcover|304|W&amp;N|2022-04-21|2023|3142|4.05<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc5ec\uae30\uc5d0 \ud5e4\ub354\ub97c \ucd9c\ub825\ud558\uace0 \uceec\ub7fc \uad6c\ubd84\uc744 \ud558\ub3c4\ub85d \ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ubc14\ub014 \uc218 \uc788\ub2e4.<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-Roboto-Mono.ttf\" style=\"font-size:clamp(14px, .875rem, 21px);font-family:Code-Pro-Roboto-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#adbac7;--cbp-line-number-width:calc(2 * 0.6 * .875rem);line-height:clamp(20px, 1.25rem, 30px);--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:flex;align-items:center;padding:10px 0px 0 16px;font-size:0.8em;width:100%;text-align:left;background-color:#22272e;font-style:italic;color:#adbac7\"><span style=\"border-bottom:1px solid rgba(139, 186, 234, 0.2)\">Plaintext<\/span><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#adbac7;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>sqlite> .headers on\nsqlite> .mode column\nsqlite> SELECT isbn,title,author FROM longlist LIMIT 5;\nisbn           title                                  author           \n-------------  -------------------------------------  -----------------\n9788439736967  Boulder                                Eva Baltasar     \n9781628971538  Whale                                  Cheon Myeong-Kwan\n9781642861181  The Gospel According to the New World  Maryse Cond\u00e9     \n9781529414431  Standing Heavy                         Gauz             \n9781474623025  Time Shelter                           Georgi Gospodinov\nsqlite> <\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark-dimmed\" style=\"background-color: #22272e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #adbac7\">sqlite&gt; .headers on<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">sqlite&gt; .mode column<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">sqlite&gt; SELECT isbn,title,author FROM longlist LIMIT 5;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">isbn           title                                  author           <\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">-------------  -------------------------------------  -----------------<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9788439736967  Boulder                                Eva Baltasar     <\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781628971538  Whale                                  Cheon Myeong-Kwan<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781642861181  The Gospel According to the New World  Maryse Cond\u00e9     <\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781529414431  Standing Heavy                         Gauz             <\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">9781474623025  Time Shelter                           Georgi Gospodinov<\/span><\/span>\n<span class=\"line\"><span style=\"color: #adbac7\">sqlite&gt; <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p>\uc8fc\uc758\ud560 \uc810\uc740 \ud56d\ubaa9\uc774 \ub9ce\ub2e4\uba74, \ucd9c\ub825\ud3ec\ub9f7\uc744 \uc9c0\uc815\ud574\ub3c4 \uc5c9\ucf1c\ubcf4\uc77c \uc218 \uc788\ub2e4. \uc704\uc758 \uacbd\uc6b0\ub294 \uae54\ub054\ud558\uac8c 3\uac1c \uceec\ub7fc\ub9cc \ucc38\uc870\ud574\ubd24\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc815\ub3c4\ub9cc \ud574\ub3c4 \ub3c4\uc6c0\uc774 \ub418\uaca0\uc9c0\ub9cc \uc774 \uc678\uc5d0\ub3c4 \ub9ce\uc740 \uba85\ub839\uc5b4\uac00 \uc788\uc73c\ub2c8, \ud55c \ubc88 \ucc3e\uc544\ubcf4\ub294 \uac83\ub3c4 \uc88b\uc744\uac83\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLite\ub97c \uc0ac\uc6a9\ud560 \ub54c, SQL\ubb38\uc774 \uc544\ub2cc sqlite \ud504\ub86c\ud504\ud2b8 \uc258 \ub0b4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \uba85\ub839\uc5b4\ub4e4\uc774 \uc788\ub2e4. CLT(Command Line Tool) \ub610\ub294 CLI(Command Line Interface)\ub77c\uace0 \ubd88\ub9b0\ub2e4. \ucd9c\ub825 \ud3ec\ub9f7\uc744 \ubcc0\uacbd\ud558\uac70\ub098, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ud14c\uc774\ube14\uc774 \ubb50\uac00 \uc788\ub294\uc9c0, \uc2a4\ud0a4\ub9c8\ub294 \uc5b4\ub5bb\uac8c \ub418\uc5b4 \uc788\ub294\uc9c0 \ub4f1\uc744 \ud655\uc778\ud558\ub294 \uc6a9\ub3c4\uc774\ub2e4. \uc2ec\uc9c0\uc5b4 export\ub3c4 \uc9c0\uc6d0\ud558\ub294\ub4f1 \uc0dd\uac01\ubcf4\ub2e4 \uae30\ub2a5\uc774 \ub9ce\uc740\ub370, \uac04\ub2e8\ud558\uac8c \uba87\uac00\uc9c0\ub9cc \uc54c\uc544\ubcf4\uc790. .help \uae30\ubcf8\uc801\uc73c\ub85c &#8216;.&#8217;, dot\uc73c\ub85c \uc2dc\uc791\ud574\uc57c \ud55c\ub2e4. \uc774 <a href=\"http:\/\/batmask.net\/index.php\/2026\/08\/14\/5555\/\" class=\"btn btn-link continue-link\">\ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[657,658,656,63,103,64],"class_list":["post-5555","post","type-post","status-publish","format-standard","hentry","category-etc","tag-cli","tag-clt","tag-dot-commands","tag-sql","tag-sqlite","tag-sqlite3"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/posts\/5555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/comments?post=5555"}],"version-history":[{"count":12,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/posts\/5555\/revisions"}],"predecessor-version":[{"id":5567,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/posts\/5555\/revisions\/5567"}],"wp:attachment":[{"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/media?parent=5555"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/categories?post=5555"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/batmask.net\/index.php\/wp-json\/wp\/v2\/tags?post=5555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}