{"height":"190","width":"100%","type":"rich","title":"MySQL \u306e SQL \u30a8\u30b9\u30b1\u30fc\u30d7","provider_url":"https://hatena.blog","published":"2013-12-15 20:50:02","categories":["MySQL"],"blog_title":"tmtms \u306e\u30e1\u30e2","author_url":"https://blog.hatena.ne.jp/tmtms/","image_url":null,"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fblog.tmtms.net%2Fentry%2F2013%2F12%2F15%2Fmysql_escape\" title=\"MySQL \u306e SQL \u30a8\u30b9\u30b1\u30fc\u30d7 - tmtms \u306e\u30e1\u30e2\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","blog_url":"https://blog.tmtms.net/","url":"https://blog.tmtms.net/entry/2013/12/15/mysql_escape","author_name":"tmtms","version":"1.0","description":"\u3053\u306e\u8a18\u4e8b\u306f MySQL Casual Advent Calendar 2013 \u306e15\u65e5\u76ee\u306e\u8a18\u4e8b\u3067\u3059\u3002 \u4eca\u3001\u7a7a\u524d\u306e SQL \u30a8\u30b9\u30b1\u30fc\u30d7\u30d6\u30fc\u30e0\u307f\u305f\u3044\u306a\u306e\u3067\u3001\u3053\u306e\u30d3\u30c3\u30b0\u30a6\u30a7\u30fc\u30d6\u306b\u4e57\u3063\u304b\u3063\u3066\u307f\u307e\u3059\u3002 \u3067\u3082\u9762\u5012\u306a\u306e\u3067\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u306b\u3064\u3044\u3066\u306e\u8a71\u306f\u3057\u307e\u305b\u3093\u3002\u30ab\u30b8\u30e5\u30a2\u30eb\uff01 \u6587\u5b57\u5217\u30ea\u30c6\u30e9\u30eb\u3068\u30a8\u30b9\u30b1\u30fc\u30d7 MySQL \u3067\u306f SQL \u4e2d\u306e\u6587\u5b57\u5217\u30ea\u30c6\u30e9\u30eb\u306f\u6b21\u306e\u3088\u3046\u306b\u8868\u73fe\u3057\u307e\u3059\u3002 'abc' -- \u30b7\u30f3\u30b0\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u62ec\u308b \"abc\" -- \u30c0\u30d6\u30eb\u30af\u30a9\u30fc\u30c8\u3067\u62ec\u308b 0x616263 -- 16\u9032\u6570 x'616263' -- 16\u9032\u6570 0b011000010110001001100011 -- 2\u9032\u6570 b'0110000101\u2026"}