{"url":"https://www.na3.jp/entry/20080702/p1","published":"2008-07-02 00:00:00","categories":["IT"],"blog_title":"\u5143RX-7\u4e57\u308a\u306e\u9069\u5f53\u306a\u65e5\u3005","provider_name":"Hatena Blog","blog_url":"https://www.na3.jp/","provider_url":"https://hatena.blog","width":"100%","author_name":"rx7","author_url":"https://blog.hatena.ne.jp/rx7/","title":"MySQL\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u540d\u3092\u5909\u66f4\u3059\u308b","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.na3.jp%2Fentry%2F20080702%2Fp1\" title=\"MySQL\u3067\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u540d\u3092\u5909\u66f4\u3059\u308b - \u5143RX-7\u4e57\u308a\u306e\u9069\u5f53\u306a\u65e5\u3005\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"height":"190","description":"\u8d85\u5099\u5fd8\u9332\u3067\u3059\u3002 DDL\u306e\u767a\u884c\u306a\u3093\u3066\u4e45\u3057\u3076\u308a\u3059\u304e\u3066\u5fd8\u308c\u6749\uff06\u30c9\u30ad\u30c9\u30ad\u3002 \u30ab\u30e9\u30e0\u540d(\u3068\u30c7\u30fc\u30bf\u578b)\u3092\u5909\u66f4\u3057\u305f\u3044\u5834\u5408 ALTER TABLE \u30c6\u30fc\u30d6\u30eb\u540d CHANGE \u53e4\u3044\u30ab\u30e9\u30e0 \u65b0\u3057\u3044\u30ab\u30e9\u30e0 \u65b0\u3057\u3044\u30c7\u30fc\u30bf\u578b; \u4f8b\uff1a alter table accounts change password crypted_password varchar(255); \u30ab\u30e9\u30e0\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5909\u66f4\u3057\u305f\u3044\u5834\u5408 ALTER TABLE \u30c6\u30fc\u30d6\u30eb\u540d MODIFY \u30ab\u30e9\u30e0\u540d \u65b0\u3057\u3044\u30c7\u30fc\u30bf\u578b; \u4f8b\uff1a alter table accounts modify crypted_password varchar(255) not null;","type":"rich","version":"1.0"}