{"categories":[],"type":"rich","blog_url":"https://fugazi.hateblo.jp/","title":"\u30ea\u30e2\u30fc\u30c8\u306emysql\u306eselect\u7d50\u679c\u3092\u30ed\u30fc\u30ab\u30eb\u306ecsv\u307e\u305f\u306ftsv\u306b\u51fa\u529b","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ffugazi.hateblo.jp%2Fentry%2F2014%2F11%2F13%2F100613\" title=\"\u30ea\u30e2\u30fc\u30c8\u306emysql\u306eselect\u7d50\u679c\u3092\u30ed\u30fc\u30ab\u30eb\u306ecsv\u307e\u305f\u306ftsv\u306b\u51fa\u529b - tips\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","version":"1.0","published":"2014-11-13 10:06:13","provider_url":"https://hatena.blog","description":"outfile\u30aa\u30d7\u30b7\u30e7\u30f3\u306f\u30d5\u30a1\u30a4\u30eb\u51fa\u529b\u5148\u304c\u30b5\u30fc\u30d0\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u306e\u3067\u30ea\u30e2\u30fc\u30c8DB\u306e\u30c7\u30fc\u30bfcsv\u7b49\u3092\u53d6\u5f97\u3059\u308b\u6642\u306b\u3061\u3087\u3063\u3068\u9762\u5012\u306a\u306e\u3067\u3001\u30ed\u30fc\u30ab\u30eb\u306b\u76f4\u63a5csv\u306a\u308atsv\u3092\u51fa\u529b\u3059\u308b\u3002 TSV\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u51fa\u529b\u3059\u308b\u5834\u5408sql\u7d50\u679c\u3092\u305d\u306e\u307e\u307e\u30d5\u30a1\u30a4\u30eb\u306b\u51fa\u529b\u3059\u308b\u3068tsv\u5f62\u5f0f\u3068\u306a\u308b\u70ba\u3053\u3093\u306a\u611f\u3058\u3067OK mysql -u [username] -p -h [host] [dbname] -e \"select foo,bar from hoge where id < 10\" > test.tsv csv\u306b\u3057\u305f\u3044\u5834\u5408\u306f\u9593\u306b\u52a0\u5de5\u51e6\u7406\u3092\u5165\u308c\u308b mysql -u [username] -p -h [host] [dbname] \u2026","blog_title":"tips","height":"190","url":"https://fugazi.hateblo.jp/entry/2014/11/13/100613","author_name":"Fugazi","author_url":"https://blog.hatena.ne.jp/Fugazi/","provider_name":"Hatena Blog","image_url":null,"width":"100%"}