{"published":"2015-02-04 19:40:33","image_url":null,"provider_name":"Hatena Blog","type":"rich","author_name":"woshidan","version":"1.0","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwoshidan.hatenadiary.jp%2Fentry%2F2015%2F02%2F04%2F194033\" title=\"\u30c9\u30f3\u30c9\u30f3\u8eab\u306b\u4ed8\u304f\u3001\u30b9\u30e9\u30b9\u30e9\u66f8\u3051\u308b\u66f8\u304d\u8fbc\u307f\u5f0fSQL\u30c9\u30ea\u30eb 4\u7ae0\u8aad\u3093\u3060 - woshidan&#39;s loose leaf\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","categories":["MySQL","\u8aad\u66f8\u9332"],"provider_url":"https://hatena.blog","author_url":"https://blog.hatena.ne.jp/woshidan/","title":"\u30c9\u30f3\u30c9\u30f3\u8eab\u306b\u4ed8\u304f\u3001\u30b9\u30e9\u30b9\u30e9\u66f8\u3051\u308b\u66f8\u304d\u8fbc\u307f\u5f0fSQL\u30c9\u30ea\u30eb 4\u7ae0\u8aad\u3093\u3060","height":"190","blog_url":"https://woshidan.hatenadiary.jp/","blog_title":"woshidan's loose leaf","description":"\u751fCREATE\u6587\u306e\u66f8\u3044\u305f\u3053\u3068\u306e\u7121\u3055\u306b\u3001 woshidan\u5148\u751f\u306e\u4e8c\u5468\u76ee\u306b\u4e5e\u3046\u3054\u671f\u5f85\u2606\u307f\u305f\u3044\u306a\u611f\u3058\u304c\u6f02\u3044\u306a\u304c\u3089\u3068\u308a\u3042\u3048\u305a\u9032\u3081\u3066\u3044\u307e\u3059\u3002 \u4e8c\u5468\u76ee\u3084\u308b\u3068\u3057\u3066\u3082\u3001\u4e00\u5468\u76ee\u306e\u30e1\u30e2\u898b\u306a\u304c\u3089\u554f\u984c\u89e3\u304f\u3060\u3051\u3060\u304b\u3089\u3060\u3044\u3076\u697d\u3067\u3059\u304c\u3002 4-1 CREATE TABLE table_name ( \u5217\u540d1 data_type column_flag, \u5217\u540d2 data_type column_flag, ... \u5236\u7d04\u6761\u4ef6, ... ) ; \u3068\u3044\u3046\u611f\u3058\u3002 \u5217\u30d5\u30e9\u30b0\u306f PRIMARY KEY(\u4e3b\u30ad\u30fc\u3002\u4ed6\u306e\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u691c\u7d22\u306b\u4f7f\u3046\u3002\u4e00\u610f\u306a\u5024\u3001NULL\u4e0d\u8a31\u53ef\u3002) UNIQUE(\u4e00\u610f\u306a\u5024\u3001NULL\u8a31\u53ef), [NOT] NULL(NULL\u2026","url":"https://woshidan.hatenadiary.jp/entry/2015/02/04/194033"}