{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftakuya-1st.hatenablog.jp%2Fentry%2F2017%2F01%2F18%2F185713\" title=\"mysql \u3067\u7121\u7cbe\u3059\u308b\u3068CREATE TABLE \u304c\u306a\u3093\u304b\u3044\u3063\u3071\u3044not null \u304c\u4ed8\u304f - \u305d\u308c\u30de\u30b0\u3067\uff01\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2017-01-18 18:57:13","blog_title":"\u305d\u308c\u30de\u30b0\u3067\uff01","author_url":"https://blog.hatena.ne.jp/takuya_1st/","height":"190","provider_name":"Hatena Blog","provider_url":"https://hatena.blog","title":"mysql \u3067\u7121\u7cbe\u3059\u308b\u3068CREATE TABLE \u304c\u306a\u3093\u304b\u3044\u3063\u3071\u3044not null \u304c\u4ed8\u304f","description":"SQL \u4f5c\u3063\u305f drop table if exists A; create table A ( id int key, title varchar(256) ); show create table A; \u5b9f\u884c\u3057\u305f A CREATE TABLE `A` ( `id` int(11) NOT NULL, `title` varchar(256) DEFAULT NULL, ) ENGINE=InnoDB DEFAULT CHARSET=latin1 not null \u306a\u3093\u304b\u3064\u3051\u305f\u899a\u3048\u306a\u3044\u306e\u306b\u3002\u3002\u3002null \u3067\u6012\u3089\u308c\u305f\u304b\u3089\u3001\u306a\u3093\u3060\u308d\u3046\u3068\u601d\u3063\u305f\u3089\u3001not null \u3064\u3044\u3066\u305f\u3002SQL\u96e3\u3057\u3044\u3002\u3002\u3002 k\u2026","type":"rich","categories":["sql"],"blog_url":"https://takuya-1st.hatenablog.jp/","author_name":"takuya_1st","image_url":null,"version":"1.0","url":"https://takuya-1st.hatenablog.jp/entry/2017/01/18/185713","width":"100%"}