{"id":94575,"date":"2020-05-09T04:52:35","date_gmt":"2020-05-08T20:52:35","guid":{"rendered":"http:\/\/4563.org\/?p=94575"},"modified":"2020-05-09T04:52:35","modified_gmt":"2020-05-08T20:52:35","slug":"mysql-%e5%ae%a2%e6%88%b7%e7%ab%af-for-visual-studio-code","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=94575","title":{"rendered":"MySQL \u5ba2\u6237\u7aef for Visual Studio Code"},"content":{"rendered":"
\n
\n
\n

MySQL \u5ba2\u6237\u7aef for Visual Studio Code <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : cweijan <\/span> <\/i> 18<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
\u76f4\u63a5\u4e0a\u94fe\u63a5: https:\/\/github.com\/cweijan\/vscode-mysql<\/p>\n

\u8fd9\u6bb5\u65f6\u95f4\u82b1\u4e86\u5927\u91cf\u65f6\u95f4\u5b8c\u5584\u8fd9\u4e2a\u63d2\u4ef6, \u76ee\u524d\u529f\u80fd\u5df2\u7ecf\u5b9e\u73b0\u6211\u6240\u9700\u8981\u7528\u5230\u7684\u529f\u80fd, \u4e3b\u8981\u63d0\u4f9b\u4e86\u4ee5\u4e0b\u529f\u80fd<\/p>\n

\u8fde\u63a5 mysql, \u5217\u51fa\u6570\u636e\u5e93\u3001\u8868\u3001\u89c6\u56fe\u7b49
\u7f16\u8f91 sql \u9ad8\u4eae\u5e76\u8fdb\u884c\u667a\u80fd\u63d0\u793a, \u5e76\u53ef\u8fd0\u884c
\u6267\u884c sql \u540e\u652f\u6301\u57fa\u672c\u7684\u589e\u5220\u6539\u67e5.
\u652f\u6301\u5907\u4efd \/\u5bfc\u51fa\u6570\u636e
\u514d\u8d39\u5f00\u6e90, \u4f7f\u7528\u7b80\u5355, \u4e0b\u8f7d 1.8M \u5de6\u53f3\u7684\u6269\u5c55\u5373\u53ef\u4f7f\u7528
\u5f00\u53d1\u521d\u8877<\/p>\n

\u5e0c\u671b\u4fdd\u6301\u4e13\u6ce8,\u4e0d\u88ab\u9891\u7e41\u5207\u6362\u8f6f\u4ef6\u5206\u6563\u6ce8\u610f\u529b
\u65e0\u8bba SqlYog\/\u8fd8\u662f NativeCat, \u90fd\u662f\u5546\u4e1a\u7248, \u9700\u8981\u7834\u89e3, \u4e14\u5176\u4e2d\u6709\u5f88\u591a\u6211\u4e0d\u9700\u8981\u7684\u529f\u80fd, \u76ee\u6807\u662f\u5f00\u53d1\u4e00\u4e2a\u7b80\u5355\u6613\u7528\u4e14\u6ee1\u8db3\u65e5\u5e38\u6570\u636e\u5e93\u64cd\u4f5c\u529f\u80fd
\"MySQL <\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (23<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Livid <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6ca1\u6709\u5f00\u53d1\u8fc7 vscode \u63d2\u4ef6\uff0c\u6240\u4ee5\u4e0b\u9762\u8fd9\u4e2a\u95ee\u9898\u53ef\u80fd\u95ee\u7684\u4e0d\u5bf9\uff1a<\/p>\n

    \u662f\u5426\u6709\u53ef\u80fd\u7528 CSS variable \u53d6\u5230\u5f53\u524d vscode theme \u7684\u5404\u79cd\u989c\u8272\u503c\uff0c\u8fd9\u6837\u4f60\u7684\u8fd9\u4e2a\u63d2\u4ef6\u91cc\u7684\u90a3\u4e2a\u7ed3\u679c\u9875\u9762\u5c31\u53ef\u4ee5\u548c\u6574\u4f53\u7684 theme \u5339\u914d\u4e86\uff1f <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : shiny <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f88\u8d5e\uff0c\u5e0c\u671b\u80fd\u652f\u6301 ssh \u8fde\u63a5\u8fdc\u7a0b MySQL <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : xcstream <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5f88\u8d5e \u5e0c\u671b\u652f\u6301 ssh tunnel +1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : infun <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u597d\u5361\u554a <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : liuxey <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : cweijan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @Livid
    1. \u5b9e\u73b0\u4e3b\u9898\u5207\u6362\u53ef\u4ee5\u5b9e\u73b0\u7684, vscode webview \u9700\u8981\u52a0\u8f7d\u6574\u4e2a html \u6587\u672c\u5185\u5bb9, \u8fdb\u884c\u5b57\u7b26\u4e32\u66ff\u6362\u5373\u53ef
    2. \u81f3\u4e8e\u6839\u636e vscode theme \u5207\u6362, \u8fd9\u4e2a\u9700\u8981\u7814\u7a76\u4e0b, \u76ee\u524d\u6ca1\u4f7f\u7528\u8fc7\u548c\u4e3b\u9898\u76f8\u5173\u7684 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Livid <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @cweijan \u770b\u8d77\u6765\u662f\u53ef\u4ee5\u8fd9\u4e48\u5e72\u7684\uff1a<\/p>\n

    https:\/\/stackoverflow.com\/a\/56759634 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : Rwing <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u65e0\u72ec\u6709\u5076\uff0c\u5fae\u8f6f\u5b98\u65b9\u6709\u4e2a\u57fa\u4e8e vscode \u7684\u6570\u636e\u5e93\u7ba1\u7406\u5de5\u5177
    https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/what-is?view=sql-server-ver15<\/p>\n

    \u652f\u6301 mysql \u597d\u50cf\u8981\u9760\u63d2\u4ef6 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : cweijan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u76ee\u524d\u95ee\u9898
    1. ssh \u96a7\u9053: \u770b\u9700\u6c42\u4eba\u6570
    2. \u5361\u987f: \u8fde\u63a5 Mysql \u65f6\u52a0\u8f7d\u6240\u6709\u8868, \u6ca1\u505a\u7ebf\u7a0b\u9650\u5236, \u7535\u8111\u914d\u7f6e\u4f4e\u53ef\u80fd\u4f1a\u6bd4\u8f83\u5361 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : djzhao <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u652f\u6301\uff01\uff01\uff01 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : kuzhan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u9700\u8981\u652f\u6301 ssh \u8fdc\u7a0b\u94fe\u63a5 +1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : agdhole <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u80fd\u652f\u6301 pgsql \u5c31\u597d\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : zer <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u67e5\u8be2\u754c\u9762\u7684 UI \u53ef\u4ee5\u66f4\u7d27\u51d1\u4e00\u4e9b\uff0c\u505a\u7684\u66f4\u50cf\u4e13\u4e1a\u7684 Mysql \u5de5\u5177 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : panzhc <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    https:\/\/marketplace.visualstudio.com\/items?itemName=mtxr.sqltools <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : MeteorCat <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u5927\u8868\u6570\u636e\u5e93\u67e5\u8be2\u4f1a\u4e0d\u4f1a\u5d29\u6e83 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : cweijan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @MeteorCat \u9ed8\u8ba4\u67e5\u8be2 100 \u6761, \u5982\u679c\u4f60\u4e0d limit, \u4e5f\u662f\u53ef\u4ee5\u67e5\u7684, \u4f46\u52a0\u8f7d\u4f1a\u5f88\u6162 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : MeteorCat <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @cweijan \u662f\u8fd9\u4e2a\u95ee\u9898\uff0c\u6211\u4ee5\u524d\u7528\u7684 MySQLFront \u8fd9\u4e2a\u5ba2\u6237\u7aef\u5c31\u662f\u8fd9\u6837\u4e00\u67e5\u5954\u6e83\uff0c\u4e3b\u8981\u662f\u6015 vsc \u4e00\u67e5\u76f4\u63a5\u4f1a\u4e0d\u4f1a\u76f4\u63a5\u628a\u6ca1\u4fdd\u5b58\u7684\u6570\u636e\u76f4\u63a5\u5f04\u70b8\u4e86 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : dandycheung <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u6b6a\u4e2a\uff1adbeaver \u4e0d\u597d\u7528\u5417\uff1f <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : spidermansam0718 <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    ssh tunnel+1 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : apeople <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u88c5\u4e86\u4e00\u4e2a\uff0c\u4e0d\u9519\uff0c\u53ef\u4ee5\u8bbe\u7f6e\u4e3b\u9898\u6216\u8005\u8ddf\u968f vsc \u4e3b\u9898\u6700\u597d\u4e86\uff0c\u6216\u8005\u6700\u8d77\u7801\u505a\u4e00\u4e2a\u6697\u9ed1\u6a21\u5f0f\u4e5f\u53ef\u4ee5 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sobigfish <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @dandycheung #18 \u4e2a\u4eba\u559c\u597d\u95ee\u9898\uff0c\u6709\u4eba\u5c31\u559c\u6b22\u4e00\u4e2a\u5de5\u5177\u5185\u5c31\u53ef\u4ee5\u5b8c\u6210\u3002<\/p>\n

    @cweijan \u5efa\u8bae\u52a0\u4e2a\u53ea\u8bfb\u6a21\u5f0f\uff0c\u6240\u6709\u7684\u5220\u5199\u64cd\u4f5c\u65e0\u6548\uff0c\u6216\u8005\u4e8c\u6b21\u786e\u8ba4 \u6709\u611f\u4e8e \/t\/664064 <\/p><\/div>\n<\/p><\/div>\n<\/li>\n

  • \n
    \n
    \n
    \u8cc7\u6df1\u5927\u4f6c : sobigfish <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    \u770b\u8fd9\u4e2a pr \u7c7b\u4f3c\u7684\u63d2\u4ef6 \uff08\u9884\u89c8 csv excel \u7684\uff09 \u5b9e\u73b0\u8ddf\u968f\u4e3b\u9898
    https:\/\/github.com\/jjuback\/gc-excelviewer\/pull\/112 <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n
    \n
    \n
    \u4e3b<\/span> \u8cc7\u6df1\u5927\u4f6c : cweijan <\/span> <\/div>\n
    <\/i> <\/span> <\/div>\n<\/p><\/div>\n
    @sobigfish \u8fd9\u4e2a\u4e0d\u9519, \u4ee5\u540e\u5c1d\u8bd5\u4e0b <\/div>\n<\/p><\/div>\n<\/li>\n
  • \n","protected":false},"excerpt":{"rendered":"

    MySQL \u5ba2\u6237\u7aef for Vis…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94575"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94575"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/94575\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=94575"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=94575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}