{"id":526,"date":"2019-12-13T14:16:59","date_gmt":"2019-12-13T05:16:59","guid":{"rendered":"http:\/\/www.fatware.jp\/?page_id=526"},"modified":"2019-12-13T14:38:35","modified_gmt":"2019-12-13T05:38:35","slug":"sql%e9%9b%86%e8%a8%88%e3%81%ae%e3%81%9f%e3%82%81%e3%81%ae%e9%80%a3%e7%95%aa%e7%94%9f%e6%88%90","status":"publish","type":"page","link":"https:\/\/www.fatware.jp\/?page_id=526","title":{"rendered":"[SQL]\u96c6\u8a08\u306e\u305f\u3081\u306e\u9023\u756a\u751f\u6210"},"content":{"rendered":"\n<p>\u3000mysql\u3067\u96c6\u8a08\u3092\u3059\u308b\u969b\u3001\u9023\u756a\u30fb\u6bce\u65e5\u3068\u3044\u3046\u7528\u9014\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f5c\u6210\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308b\u3002\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u306b\u306fmysql\u306e\u5909\u6570\u3092\u5229\u7528\u3057\u3066\u7c21\u5358\u306b\u5143\u3068\u306a\u308b\u6574\u6570\u5024\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002\u306a\u304a\u3001\u6700\u65b0\u306emariadb\u3067\u306f\u30b7\u30fc\u30b1\u30f3\u30b9\u30a8\u30f3\u30b8\u30f3\u3082\u5229\u7528\u3067\u304d\u308b\u306e\u3060\u304c\u3001RedHat7\u7cfb\u306emariadb\u306f5.x\u7cfb\u306a\u306e\u3067\u6a19\u6e96\u3067\u5229\u7528\u3067\u304d\u306a\u3044\u305f\u3081\u3001\u6614\u304b\u3089\u3042\u308b\u5909\u6570\u3092\u5229\u7528\u3057\u3066\u751f\u6210\u3059\u308b\u306e\u304c\u671b\u307e\u3057\u3044\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">mysql\u306e\u5909\u6570<\/h2>\n\n\n\n<p>\u3000\u307e\u305amysql\u306e\u5909\u6570\u306f\uff20\u30de\u30fc\u30af\u304b\u3089\u59cb\u307e\u308b\u6587\u5b57\u3067\u5909\u6570\u3092\u5b9a\u7fa9\u3067\u304d\u308b\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nset @a ;\nset @b=0;\nset @c=1,@d=2;\n<\/pre><\/div>\n\n\n<p>\u3000\u8a2d\u5b9a\u3057\u305f\u5909\u6570\u306f\u30bb\u30c3\u30b7\u30e7\u30f3\u4e2d\u306f\u6709\u52b9\u3067\u3042\u308a\u3001\u30b0\u30ed\u30fc\u30d0\u30eb\u5909\u6570\u306e\u3088\u3046\u306b\u5229\u7528\u3067\u304d\u308b\u3002\u3059\u306a\u308f\u3061\u3001\u8a2d\u5b9a\u3057\u305f\u5909\u6570\u3092\u5909\u66f4\u3057\u305f\u5834\u5408\u306b\u306f\u3001\u30bb\u30c3\u30b7\u30e7\u30f3\u7d42\u4e86\u307e\u3067\u540c\u3058\u5024\u3092\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\u3000\u5024\u3092\u5165\u308c\u305f\u5909\u6570\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8868\u793a\u30fb\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect @c;\n<\/pre><\/div>\n\n\n<p>\u3000\u5909\u6570\u306e\u5024\u3092\u66f4\u65b0\u3057\u305f\u3044\u5834\u5408\u306b\u306f\u3001\u30b3\u30ed\u30f3\u3092\u5229\u7528\u3059\u308b\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nMariaDB &#x5B;]&gt; set @a=0;\n  Query OK, 0 rows affected (0.00 sec)\n\nMariaDB &#x5B;]&gt; select @a:=@a+1;\n+----------+\n| @a:=@a+1 |\n+----------+\n|     1    |\n+----------+\n1 row in set (0.00 sec)\n\nMariaDB &#x5B;]&gt; select @a;\n+------+\n|  @a  |\n+------+\n|   1  |\n+------+\n1 row in set (0.00 sec)\n<\/pre><\/div>\n\n\n<p>\u3000\u3053\u306e\u3088\u3046\u306b\u3001select\u306e\u4e2d\u3067\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\uff08\uff0b\uff11\uff09\u3067\u304d\u308b\u306e\u3067\u9023\u756a\u751f\u6210\u306b\u5229\u7528\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308b\u3002select\u4e2d\u3067\u4e00\u5ea6\u3067\u3082\u5909\u66f4\u3057\u305f\u3082\u306e\u306f\u30bb\u30c3\u30b7\u30e7\u30f3\u304c\u7d42\u4e86\u3059\u308b\u307e\u3067\u3001\u540c\u3058\u5024\u3092\u4fdd\u5b58\u3057\u3066\u3044\u308b\u3002\u307e\u305fset\u3067\u518d\u5ea6@a=0\u306e\u3088\u3046\u306b\u521d\u671f\u5316\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u308b\u3002\u3053\u3053\u307e\u3067\u3067\u5909\u6570\u306e\u5b9a\u7fa9\u3068\u3001\u66f4\u65b0\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u305f\u3002\u6b21\u306f\u3053\u308c\u3092\u5fdc\u7528\u3057\u3066\u9023\u756a\u30c7\u30fc\u30bf\u3092\u751f\u6210\u3059\u308b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u9023\u756a\u30c7\u30fc\u30bf\u306e\u751f\u6210<\/h2>\n\n\n\n<p>\u3000\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u5b9f\u884c\u3059\u308b\u3053\u3068\u3067\u4f5c\u6210\u3067\u304d\u308b\u3002<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nset @a=0;select @a:=@a+1 from \uff1c\u9069\u5ea6\u306b\u30bf\u30d7\u30eb\u306e\u591a\u3044\u30c6\u30fc\u30d6\u30eb\uff1e;\nset @a=0;select @a:=@a+1 from information_schema.columns;\n<\/pre><\/div>\n\n\n<p>1\u884c\u3067\u66f8\u3044\u3066\u3044\u308b\u304c\u6700\u521d\u306eset\u3067\u5909\u6570\u3092\u521d\u671f\u5316\u3057\u3001\u6b21\u306eselect\u3067\uff0b\uff11\u3057\u306a\u304c\u3089@a\u3092\u8868\u793a\u3057\u3066\u3044\u3063\u3066\u3044\u308b\u3002\u8868\u793a\u306e\u56de\u6570\u306ffrom\u4ee5\u964d\u3067\u6307\u5b9a\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306e\u500b\u6570\u3067\u8868\u793a\u3055\u308c\u308b\u3002\u3064\u307e\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u4e2d\u8eab\u306f\u4e00\u5207\u5229\u7528\u3057\u3066\u3044\u306a\u3044\u304c\u3001\u500b\u6570\u304c\u5fc5\u8981\u3068\u306a\u308b\u3002\u6a19\u6e96\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f information_schema.columns\u30c6\u30fc\u30d6\u30eb\u306f\u79c1\u306e\u74b0\u5883\u3067\u306f5000\u500b\u7a0b\u5ea6\u306e\u30bf\u30d7\u30eb\u304c\u3042\u308a\u30015000\u307e\u3067\u751f\u6210\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p>\u3000\u4eca\u5ea6\u306f\u3053\u306e\u9023\u756aQuery\u3092\u30b5\u30d6\u30af\u30a8\u30ea\u3068\u3057\u3066JOIN\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u308c\u3092\u30a8\u30f3\u30b8\u30f3\u3068\u3057\u3066\u3001\u30af\u30ed\u30b9\u96c6\u8a08\u306e\u969b\u306e\u629c\u3051\u305f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u751f\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3000mysql\u3067\u96c6\u8a08\u3092\u3059\u308b\u969b\u3001\u9023\u756a\u30fb\u6bce\u65e5\u3068\u3044\u3046\u7528\u9014\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f5c\u6210\u3057\u305f\u3044\u5834\u5408\u304c <a href=\"https:\/\/www.fatware.jp\/?page_id=526\" class=\"read-more\">\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":363,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-526","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=526"}],"version-history":[{"count":3,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/526\/revisions"}],"predecessor-version":[{"id":530,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/526\/revisions\/530"}],"up":[{"embeddable":true,"href":"https:\/\/www.fatware.jp\/index.php?rest_route=\/wp\/v2\/pages\/363"}],"wp:attachment":[{"href":"https:\/\/www.fatware.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}