{"width":"100%","author_url":"https://blog.hatena.ne.jp/dk521123/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdk521123.hatenablog.com%2Fentry%2F36461359\" title=\"\u3010MySQL\u3011 MySQL \u3067\u3001\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316 / \u5fa9\u53f7\u5316 \u3059\u308b - \u30d7\u30ed\u30b0\u30e9\u30e0 \u306e\u8d85\u500b\u4eba\u7684\u306a\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>","title":"\u3010MySQL\u3011 MySQL \u3067\u3001\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316 / \u5fa9\u53f7\u5316 \u3059\u308b","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","description":"\u25a0 MySQL \u3067\u3001\u30c7\u30fc\u30bf\u3092\u6697\u53f7\u5316 / \u5fa9\u53f7\u5316 \u3059\u308b \u65b9\u6cd5 * AES_ENCRYPT() / AES_DECRYPT() \u306a\u3069\u306e\u6697\u53f7\u5316\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b https://dev.mysql.com/doc/refman/5.6/ja/encryption-functions.html \u25a0 \u4f8b\uff11 \u30c6\u30fc\u30d6\u30eb CREATE TABLE IF NOT EXISTS `user` ( `user_id` VARCHAR(100) NOT NULL, `password` VARBINARY(200) NOT NULL, -- VARBINARY\u3092\u4f7f\u7528\u3059\u308b PRIMARY KEY (`user_id`) )\u2026","height":"190","author_name":"dk521123","published":"2016-10-24 22:43:52","type":"rich","blog_url":"https://dk521123.hatenablog.com/","image_url":null,"version":"1.0","url":"https://dk521123.hatenablog.com/entry/36461359","blog_title":"\u30d7\u30ed\u30b0\u30e9\u30e0 \u306e\u8d85\u500b\u4eba\u7684\u306a\u30e1\u30e2","categories":["MySQL"]}