{"id":98,"date":"2021-07-15T18:41:50","date_gmt":"2021-07-15T10:41:50","guid":{"rendered":"http:\/\/www.citerp.com.tw\/citwp2\/?p=98"},"modified":"2022-10-13T20:56:21","modified_gmt":"2022-10-13T12:56:21","slug":"phpmyadmin-001","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/","title":{"rendered":"PHPMyAdmin \u5b89\u88dd\u6559\u5b78"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">\u6587\u7ae0\u76ee\u9304<\/p><ul class=\"toc_list\"><li><a href=\"#phpMyAdmin\"><span class=\"toc_number toc_depth_1\">1<\/span> \u4ec0\u9ebc\u662fphpMyAdmin\uff1f<\/a><\/li><li><a href=\"#phpMyAdmin-2\"><span class=\"toc_number toc_depth_1\">2<\/span> phpMyAdmin\u5b89\u88dd\u6b65\u9a5f<\/a><\/li><\/ul><\/div>\n\n<h2 class=\"wp-block-heading\"><span id=\"phpMyAdmin\">\u4ec0\u9ebc\u662fphpMyAdmin\uff1f<\/span><\/h2>\n\n\n\n<p class=\"has-large-font-size\">phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span id=\"phpMyAdmin-2\">phpMyAdmin\u5b89\u88dd\u6b65\u9a5f<\/span><\/h2>\n\n\n\n<p class=\"has-large-font-size\">\u4e00\u3001<a rel=\"noreferrer noopener\" href=\"https:\/\/www.phpmyadmin.net\/downloads\/\" target=\"_blank\" data-type=\"URL\" data-id=\"https:\/\/www.phpmyadmin.net\/downloads\/\">\u4e0b\u8f09phpMyAdmin<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\" rel=\"lightbox[98]\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"698\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\" alt=\"\" class=\"wp-image-77\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg 698w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-300x300.jpg 300w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-150x150.jpg 150w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-88x88.jpg 88w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-large-font-size\">\u4e8c\u3001\u89e3\u58d3\u7e2e\u653e\u81f3C:\\xampp\u4e0b\u3002<\/p>\n\n\n\n<p class=\"has-normal-font-size\">\u4e0b\u8f09\u5b8c\u5f8c\u89e3\u58d3\u7e2e\u6a94\u6848\uff0c\u653e\u81f3C:\\xampp\u4e0b\uff0c\u5c07\u8cc7\u6599\u593e\u66f4\u540d\u70baphpMyAdmin\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002.jpg\" rel=\"lightbox[98]\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"570\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002.jpg\" alt=\"\" class=\"wp-image-75\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002.jpg 961w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002-300x178.jpg 300w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002-768x456.jpg 768w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin002-816x484.jpg 816w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n\t<ins class=\"adsbygoogle\" style=\"display:block\" data-ad-client=\"ca-pub-7536970353732438\" data-ad-slot=\"2906002114\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<p class=\"has-large-font-size\">\u4e09\u3001\u66f4\u6539config.inc.php\u3002<\/p>\n\n\n\n<p class=\"has-normal-font-size\">\u8907\u88fd&nbsp;config.sample.inc.php \u6a94\u6848\u4e26\u5c07\u5176\u66f4\u540d\u70ba&nbsp;config.inc.php \u7528\u7de8\u8f2f\u5668\u958b\u555f\u5b83\uff0c\u66f4\u6539\u90e8\u5206\u5167\u5bb9\u5982\u4e0b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin003.jpg\" rel=\"lightbox[98]\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"281\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin003.jpg\" alt=\"\" class=\"wp-image-76\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin003.jpg 573w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin003-300x147.jpg 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-large-font-size\">\u56db\u3001\u958b\u555fphpMyAdmin\u3002<\/p>\n\n\n\n<p class=\"has-normal-font-size\">\u958b\u555f\u700f\u89bd\u5668\uff0c\u7db2\u5740\u5217\u8f38\u5165 http:\/\/localhost\/phpMyAdmin\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-1.jpg\" rel=\"lightbox[98]\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"587\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-1.jpg\" alt=\"\" class=\"wp-image-78\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-1.jpg 698w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-1-300x252.jpg 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/a><\/figure>\n\n\n\n<p class=\"has-large-font-size\">\u56db\u3001\u5efa\u7acb\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<p class=\"has-normal-font-size\">\u9ede\u64ca\u300c\u8cc7\u6599\u5eab\u300d -&gt; \u8f38\u5165\u540d\u7a31 (\u9650\u82f1\u6587\u3001\u6578\u5b57\u3001\u5e95\u7dda) -&gt; \u5efa\u7acb\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005.jpg\" rel=\"lightbox[98]\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"612\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005-1024x612.jpg\" alt=\"\" class=\"wp-image-79\" srcset=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005-1024x612.jpg 1024w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005-300x179.jpg 300w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005-768x459.jpg 768w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005-816x487.jpg 816w, https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin005.jpg 1090w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">\u8cc7\u6599\u5eab\u5efa\u597d\u4e86\uff0c\u770b\u8d77\u4f86\u4e00\u5207OK..<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p> \ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/18\/wordpress-002\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u8a2d\u5b9a WordPress \u7db2\u7ad9\u7684\u5716\u793a (Favicon)<\/a><\/p>\n\n\n\n<p> \ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/08\/02\/woocommerce-set1\/\" target=\"_blank\" rel=\"noreferrer noopener\">WooCommerce \u5b89\u88dd\u8a2d\u5b9a<\/a><\/p>\n\n\n\n<p> \ud83d\udc49<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/11\/11\/phpmyadmin-002\/\" target=\"_blank\" rel=\"noreferrer noopener\">PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u5eab)<\/a><\/p>\n\n\n\n<span style=\"font-family:DFKai-sb; line-height:60px; font-size:24px;;color:#E800E8;\">\ud83d\udca5\u76f8\u95dc\u6587\u7ae0\ud83d\udca5<\/span>\n\n\n<div class=\"wp-block-qubely-postgrid qubely-block-71c964\"><div class=\"qubely-postgrid-wrapper  qubely-postgrid-layout-1\" ><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/12\/01\/phpmyadmin-003\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/12\/image-5-768x445.png\" alt=\"PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u8868)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2021-12-01<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/12\/01\/phpmyadmin-003\/\">PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u8868)<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u672c\u7ae0\u7bc0\u8981\u5b78\u7fd2\u5982\u4f55\u5efa\u7acbMySQL\u8cc7\u6599\u8868(table)\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/12\/01\/phpmyadmin-003\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-006\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/01\/phpmyadmin008-768x479.jpg\" alt=\"PHPMyAdmin \u6559\u5b78(\u9084\u539fMySQL\u8cc7\u6599\u5eab)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-01-05<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-006\/\">PHPMyAdmin \u6559\u5b78(\u9084\u539fMySQL\u8cc7\u6599\u5eab)<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u672c\u7ae0\u7bc0\u8981\u5b78\u7fd2\u5982\u4f55\u4f7f\u7528phpmyadmin\u9084\u539fMySQL\u8cc7\u6599\u5eab\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-006\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-005\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/01\/phpmyadmin006-768x446.jpg\" alt=\"PHPMyAdmin \u6559\u5b78(\u5099\u4efdMySQL\u8cc7\u6599\u5eab)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-01-05<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-005\/\">PHPMyAdmin \u6559\u5b78(\u5099\u4efdMySQL\u8cc7\u6599\u5eab)<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u672c\u7ae0\u7bc0\u8981\u5b78\u7fd2\u5982\u4f55\u4f7f\u7528phpmyadmin\u5099\u4efdMySQL\u8cc7\u6599\u5eab\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/01\/05\/phpmyadmin-005\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\" alt=\"PHPMyAdmin \u5b89\u88dd\u6559\u5b78\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2021-07-15<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\">PHPMyAdmin \u5b89\u88dd\u6559\u5b78<\/a><\/h3><div class=\"qubely-postgrid-intro\">phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/11\/11\/phpmyadmin-002\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/11\/image-1-768x453.png\" alt=\"PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u5eab)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2021-11-11<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/11\/11\/phpmyadmin-002\/\">PHPMyAdmin \u6559\u5b78(\u5efa\u7acbMySQL\u8cc7\u6599\u5eab)<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u672c\u7ae0\u7bc0\u8981\u5b78\u7fd2\u5982\u4f55\u4f7f\u7528phpmyadmin\u5efa\u7acbMySQL\u8cc7\u6599\u5eab\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/11\/11\/phpmyadmin-002\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid-pagination\"><\/div><\/div>\n\n\n<span style=\"font-family:DFKai-sb; line-height:60px; font-size:24px;;color:#E800E8;\">\ud83d\udc47\u66f4\u591a\u6587\u7ae0\ud83d\udc47<\/span>\n\n\n<div class=\"wp-block-qubely-postgrid qubely-block-5b81de\"><div class=\"qubely-postgrid-wrapper  qubely-postgrid-layout-1\" ><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/14\/sql-16\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/10\/sql-16-1-e1666078975120-768x399.png\" alt=\"[MS-SQL]\u5982\u4f55\u53d6\u5f97\u76ee\u524d\u6240\u5728\u7684\u8cc7\u6599\u5eab\u540d\u7a31(DB NAME)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-10-14<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/14\/sql-16\/\">[MS-SQL]\u5982\u4f55\u53d6\u5f97\u76ee\u524d\u6240\u5728\u7684\u8cc7\u6599\u5eab\u540d\u7a31(DB NAME)<\/a><\/h3><div class=\"qubely-postgrid-intro\">[sql server]\u8981\u5982\u4f55\u53d6\u5f97\u76ee\u524d\u6240\u5728\u8cc7\u6599\u5eab\u540d\u7a31\u5462? \u8a9e\u6cd5\uff1a \u5be6\u4f5c\uff1a \u5982\u679c\u8981\u53d6\u5f97\u6240\u6709\u8cc7\u6599\u5eab\u540d\u7a31\u8a72\u5982\u4f55\u4e0b\u6307\u4ee4 &#8230; <a title=\"[MS-SQL]\u5982\u4f55\u53d6\u5f97\u76ee\u524d\u6240\u5728\u7684\u8cc7\u6599\u5eab\u540d\u7a31(DB NAME)\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/14\/sql-16\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc [MS-SQL]\u5982\u4f55\u53d6\u5f97\u76ee\u524d\u6240\u5728\u7684\u8cc7\u6599\u5eab\u540d\u7a31(DB <\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/14\/sql-16\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/18\/sql-18\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/10\/sql-18-1-768x450.png\" alt=\"[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE TABLE\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-10-18<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/18\/sql-18\/\">[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE TABLE<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u8cc7\u6599\u8868\u683c\u662f\u8cc7\u6599\u5eab\u4e2d\u5132\u5b58\u8cc7\u6599\u7684\u57fa\u672c\u67b6\u69cb\uff0c\u6240\u4ee5\u901a\u5e38\u60a8\u6703\u9700\u8981\u81ea\u5df1\u5728\u8cc7\u6599\u5eab\u4e2d\u5efa\u7acb\u8cc7\u6599\u8868\u683c\u3002\u7576\u6211\u5011\u7528Create Tab &#8230; <a title=\"[MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE TABLE\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/18\/sql-18\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc [MS-SQL]\u5efa\u7acb\u8cc7\u6599\u8868\u683c CREATE <\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/18\/sql-18\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/09\/08\/sql-12\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/09\/image-1.png\" alt=\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-09-08<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/09\/08\/sql-12\/\">[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u5728\u5b57\u4e32\u4e2d\u641c\u5c0b\u7279\u5b9a\u5b50\u5b57\u4e32\u51fa\u73fe\u4f4d\u7f6e CHARINDEX CHARINDEX -&gt; \u641c\u5c0b\u5b50\u5b57\u4e32\u51fa\u73fe\u4f4d\u7f6e \u8a9e\u6cd5\uff1a &#8230; <a title=\"[MS-SQL]\u5b57\u4e32\u8655\u7406-\u627e\u5b57\u4e32\u4f4d\u7f6e\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/09\/08\/sql-12\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc [MS-SQL]\u5b57\u4e32\u8655\u7406<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/09\/08\/sql-12\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2023\/06\/06\/sql-22\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2023\/06\/sql-22-3.png\" alt=\"\u521d\u6b21\u4f7f\u7528SQL Server \u67e5\u8a62EXCEL \u7684\u8cc7\u6599\u9047\u5230\u7684\u5404\u7a2e\u554f\u984c\u5982\u4f55\u89e3\u6c7a\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2023-06-06<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2023\/06\/06\/sql-22\/\">\u521d\u6b21\u4f7f\u7528SQL Server \u67e5\u8a62EXCEL \u7684\u8cc7\u6599\u9047\u5230\u7684\u5404\u7a2e\u554f\u984c\u5982\u4f55\u89e3\u6c7a<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u72c0\u6cc1: \u7576\u767c\u751fSQL Server \u5df2\u5c01\u9396\u5143\u4ef6 &#8216;Ad Hoc Distributed Queri &#8230; <a title=\"\u521d\u6b21\u4f7f\u7528SQL Server \u67e5\u8a62EXCEL \u7684\u8cc7\u6599\u9047\u5230\u7684\u5404\u7a2e\u554f\u984c\u5982\u4f55\u89e3\u6c7a\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2023\/06\/06\/<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2023\/06\/06\/sql-22\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/18\/wordpress-002\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/WordPress027.jpg\" alt=\"\u8a2d\u5b9a WordPress \u7db2\u7ad9\u7684\u5716\u793a (Favicon)\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2021-07-18<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/18\/wordpress-002\/\">\u8a2d\u5b9a WordPress \u7db2\u7ad9\u7684\u5716\u793a (Favicon)<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u700f\u89bd\u5668\u958b\u555f\u5f88\u591a\u5206\u9801\uff0c\u6bcf\u4e00\u500b\u5206\u9801\u4ee3\u8868\u4e00\u500b\u7db2\u9801\uff0c\u5206\u9801\u4e0a\u65b9\u6709\u7db2\u9801\u7684\u6a19\u984c\uff0c\u6a19\u984c\u65c1\u7684\u5c0f\u5716\u793a\u5c31\u662fFavicon \u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/18\/wordpress-002\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\" alt=\"PHPMyAdmin \u5b89\u88dd\u6559\u5b78\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2021-07-15<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\">PHPMyAdmin \u5b89\u88dd\u6559\u5b78<\/a><\/h3><div class=\"qubely-postgrid-intro\">phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-19\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/11\/sql-19-1-768x388.png\" alt=\"[MS-SQL]\u6392\u5e8f\u67e5\u8a62 ORDER BY\u3001\u6307\u5b9a\u67e5\u8a62\u8cc7\u6599\u5217\u6578\u76ee TOP\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-11-05<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-19\/\">[MS-SQL]\u6392\u5e8f\u67e5\u8a62 ORDER BY\u3001\u6307\u5b9a\u67e5\u8a62\u8cc7\u6599\u5217\u6578\u76ee TOP<\/a><\/h3><div class=\"qubely-postgrid-intro\">\u6211\u5011\u53ef\u4ee5\u5728\u4e0b SELECT \u8a9e\u6cd5\u6642\uff0c\u52a0\u5165 ORDER BY \u4f86\u4f9d\u67d0\u6b04\u4f4d\u505a\u6392\u5e8f\uff0c\u800c\u6392\u5e8f\u53ef\u4ee5\u7531\u5c0f\u81f3\u5927 (ASC\uff1ba &#8230; <a title=\"[MS-SQL]\u6392\u5e8f\u67e5\u8a62 ORDER BY\u3001\u6307\u5b9a\u67e5\u8a62\u8cc7\u6599\u5217\u6578\u76ee TOP\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/<\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/11\/05\/sql-19\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/30\/sql-9\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/sql-9-0.png\" alt=\"[MS-SQL]\u4f7f\u7528CONVERT\u8f49\u63db\u6642\u9593\u683c\u5f0fDatetime\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-06-30<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/30\/sql-9\/\">[MS-SQL]\u4f7f\u7528CONVERT\u8f49\u63db\u6642\u9593\u683c\u5f0fDatetime<\/a><\/h3><div class=\"qubely-postgrid-intro\">CONVERT\u80fd\u5c07\u6642\u9593\u683c\u5f0fDatetime\uff0c\u8f49\u63db\u6210\u591a\u7a2eVarchar\u578b\u614b\u7684\u683c\u5f0f\u3002 \ud83d\udc49[MS-SQL]\u4f7f\u7528quo &#8230; <a title=\"[MS-SQL]\u4f7f\u7528CONVERT\u8f49\u63db\u6642\u9593\u683c\u5f0fDatetime\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/30\/sql-9\/\" <\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/30\/sql-9\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/07\/sql-13\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/10\/sql-13-1-768x652.png\" alt=\"[MS-SQL] While \u8ff4\u5708\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-10-07<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/07\/sql-13\/\">[MS-SQL] While \u8ff4\u5708<\/a><\/h3><div class=\"qubely-postgrid-intro\">SQL Server\u7684while\u8ff4\u5708\u96d6\u7136\u4e0d\u5e38\u4f7f\u7528\uff0c\u4f46\u662f\u7576\u6709\u8cc7\u6599\u9700\u8981\u6279\u6b21\u8b80\u53d6\u548c\u904b\u7b97\u6642\uff0c\u9019\u6642\u5019\u7684while\u8ff4\u5708\u5c31\u76f8 &#8230; <a title=\"[MS-SQL] While \u8ff4\u5708\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/07\/sql-13\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc [MS-SQL] <\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/10\/07\/sql-13\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid qubely-post-list-view qubely-postgrid-style-2\"><div class=\"qubely-post-list-wrapper qubely-post-list-center\"><div class=\"qubely-post-list-img qubely-post-img qubely-post-img-zoom-out\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/08\/sql-004\/\"><img decoding=\"async\" class=\"qubely-post-image\" src=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/sql-004-02-768x338.png\" alt=\"[MS-SQL]\u4e2dDataLength()\u8207Len()\u7684\u5340\u5225\"\/><\/a><\/div><div class=\"qubely-post-list-content\"><div class=\"qubely-postgrid-meta\"><span><i class=\"far fa-calendar-alt\"><\/i> 2022-06-08<\/span><\/div><h3 class=\"qubely-postgrid-title\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/08\/sql-004\/\">[MS-SQL]\u4e2dDataLength()\u8207Len()\u7684\u5340\u5225<\/a><\/h3><div class=\"qubely-postgrid-intro\">Len()\u3001DataLength()\u6e2c\u91cf\u6307\u5b9a\u9577\u5ea6\u7684\u51fd\u6578\u3002 Len() -&gt; \u8a08\u7b97\u5b57\u7b26\u4e32\u500b\u6578\uff0c\u4e0d\u5340\u5206\u4e2d\u82f1\u6587 &#8230; <a title=\"[MS-SQL]\u4e2dDataLength()\u8207Len()\u7684\u5340\u5225\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/08\/sql-004\/\" <\/div><div class=\"qubely-postgrid-btn-wrapper\"><a class=\"qubely-postgrid-btn qubely-button-fill is-small\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/08\/sql-004\/\">\u95b1\u8b80\u66f4\u591a..<\/a><\/div><\/div><\/div><\/div><\/div><div class=\"qubely-postgrid-pagination\"><span aria-current=\"page\" class=\"page-numbers current\">1<\/span>\n<a class=\"page-numbers\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/page\/2\/\">2<\/a>\n<a class=\"page-numbers\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/page\/3\/\">3<\/a>\n<span class=\"page-numbers dots\">&#8230;<\/span>\n<a class=\"page-numbers\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/page\/5\/\">5<\/a>\n<a class=\"next page-numbers\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/page\/2\/\">Next <span class='fas fa-angle-right'><\/span><\/a><\/div><\/div>\n\n\n<!-- \u95dc\u6389\u6700\u65b0\u6587\u7ae0\u4e0a\u4e0b\u9801\u986f\u793a -->\n<style type=\"text\/css\">\n.qubely-postgrid-pagination{\ndisplay:none;\n}\n<\/style>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002<\/p>\n","protected":false},"author":1,"featured_media":77,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","footnotes":""},"categories":[5,9],"tags":[32],"class_list":["post-98","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-phpmyadmin","category-program","tag-phpmyadmin"],"qubely_featured_image_url":{"full":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"portraits":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",320,320,false],"thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-150x150.jpg",150,150,true],"medium":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004-300x300.jpg",300,300,true],"medium_large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"1536x1536":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"2048x2048":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"qubely_landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",698,698,false],"qubely_portrait":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",320,320,false],"qubely_thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg",100,100,false]},"qubely_author":{"display_name":"\u5927\u53d4","author_link":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"},"qubely_comment":3,"qubely_category":"<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/category\/phpmyadmin\/\" rel=\"category tag\">PHPMyAdmin<\/a> <a href=\"https:\/\/www.citerp.com.tw\/citwp2\/category\/program\/\" rel=\"category tag\">\u7a0b\u5f0f\u8a9e\u8a00<\/a>","qubely_excerpt":"phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf...","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PHPMyAdmin \u5b89\u88dd\u6559\u5b78 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHPMyAdmin \u5b89\u88dd\u6559\u5b78 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\" \/>\n<meta property=\"og:site_name\" content=\"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-15T10:41:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-13T12:56:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"698\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5927\u53d4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/\",\"name\":\"\\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"description\":\"\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u5584\\u7528\\u7db2\\u8def\\u8cc7\\u6e90\\u627e\\u5230\\u66f4\\u7f8e\\u597d\\u7684\\u751f\\u6d3b..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#primaryimage\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\",\"contentUrl\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg\",\"width\":698,\"height\":698},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#webpage\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\",\"name\":\"PHPMyAdmin \\u5b89\\u88dd\\u6559\\u5b78 - \\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"isPartOf\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#primaryimage\"},\"datePublished\":\"2021-07-15T10:41:50+00:00\",\"dateModified\":\"2022-10-13T12:56:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\\u9996\\u9801\",\"item\":\"https:\/\/www.citerp.com.tw\/citwp2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHPMyAdmin \\u5b89\\u88dd\\u6559\\u5b78\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\",\"name\":\"\\u5927\\u53d4\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"caption\":\"\\u5927\\u53d4\"},\"sameAs\":[\"http:\/\/localhost\/wp2\"],\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHPMyAdmin \u5b89\u88dd\u6559\u5b78 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/","og_locale":"zh_TW","og_type":"article","og_title":"PHPMyAdmin \u5b89\u88dd\u6559\u5b78 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","og_description":"phpMyAdmin\u662f\u5ee3\u70ba\u6d41\u50b3\u7684\u7dda\u4e0a\u7ba1\u7406MySQL\u5957\u4ef6\u7db2\u9801\uff0c\u5c0d\u65bc MySQL \u8cc7\u6599\u5eab\u7684\u4f7f\u7528\u8005\u4f86\u8b1b\uff0c\u662f\u500b\u975e\u5e38\u65b9\u4fbf\u7684\u5957\u4ef6\u3002","og_url":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/","og_site_name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","article_published_time":"2021-07-15T10:41:50+00:00","article_modified_time":"2022-10-13T12:56:21+00:00","og_image":[{"width":698,"height":698,"url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u5927\u53d4","Est. reading time":"2 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website","url":"https:\/\/www.citerp.com.tw\/citwp2\/","name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","description":"\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u5584\u7528\u7db2\u8def\u8cc7\u6e90\u627e\u5230\u66f4\u7f8e\u597d\u7684\u751f\u6d3b..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-TW"},{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#primaryimage","inLanguage":"zh-TW","url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg","contentUrl":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2021\/07\/phpmyadmin004.jpg","width":698,"height":698},{"@type":"WebPage","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#webpage","url":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/","name":"PHPMyAdmin \u5b89\u88dd\u6559\u5b78 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","isPartOf":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#primaryimage"},"datePublished":"2021-07-15T10:41:50+00:00","dateModified":"2022-10-13T12:56:21+00:00","author":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007"},"breadcrumb":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2021\/07\/15\/phpmyadmin-001\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/www.citerp.com.tw\/citwp2\/"},{"@type":"ListItem","position":2,"name":"PHPMyAdmin \u5b89\u88dd\u6559\u5b78"}]},{"@type":"Person","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007","name":"\u5927\u53d4","image":{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo","inLanguage":"zh-TW","url":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","caption":"\u5927\u53d4"},"sameAs":["http:\/\/localhost\/wp2"],"url":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":11,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":2839,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/98\/revisions\/2839"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media\/77"}],"wp:attachment":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}