{"version":"1.0","height":"190","provider_url":"https://hatena.blog","width":"100%","title":"\u3088\u3046\u3053\u305d\u2026\u300e\u7537\u306e\u4e16\u754c\u300f\u3078\u2026\uff08AUTO_INCREMENT\u304c\u5dfb\u304d\u623b\u308b\u304a\u8a71\uff09","categories":["MySQL"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fnext4us-ti.hatenablog.com%2Fentry%2F2020%2F03%2F27%2F161850\" title=\"\u3088\u3046\u3053\u305d\u2026\u300e\u7537\u306e\u4e16\u754c\u300f\u3078\u2026\uff08AUTO_INCREMENT\u304c\u5dfb\u304d\u623b\u308b\u304a\u8a71\uff09 - 41\u304b\u3089\u59cb\u3081\u307e\u3057\u305f\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","blog_url":"https://next4us-ti.hatenablog.com/","type":"rich","image_url":null,"url":"https://next4us-ti.hatenablog.com/entry/2020/03/27/161850","author_name":"next4us-ti","blog_title":"41\u304b\u3089\u59cb\u3081\u307e\u3057\u305f","published":"2020-03-27 16:18:50","provider_name":"Hatena Blog","description":"AUTO_INCREMENT\u304c\u5dfb\u304d\u623b\u308b \u4eca\u306e\u4f1a\u793e\u306b\u5165\u308b\u307e\u3067\u77e5\u3089\u306a\u304b\u3063\u305f\u3093\u3067\u3059\u304c\u3001\u7d50\u69cb\u6709\u540d\u306a\u30d0\u30b0\u3063\u307d\u3044\u3067\u3059\u306d\u3002 AUTO_INCREMENT\u3067\u63a1\u756a\u3055\u308c\u305f\u756a\u53f7\u304c\u3001\u518d\u8d77\u52d5\u3059\u308b\u3068MySQL5.7\u4ee5\u524d\u306f\u5dfb\u304d\u623b\u308b\u73fe\u8c61\u304c\u8d77\u304d\u308b\u8a71\u3067\u3059\u3002 \u518d\u73fe\u3057\u3066\u307f\u308b MySQL5.7\u30688.0\u306b\u305d\u308c\u305e\u308c\u540c\u3058\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u3063\u3066\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3001\u6700\u65b0\u306e\u884c\u3092\u524a\u9664\u3057\u307e\u3059\u3002 \u5171\u901a mysql> use test; Database changed mysql> CREATE TABLE `t1` ( -> `id` int(11) NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (`id`) -> ) ENGI\u2026","author_url":"https://blog.hatena.ne.jp/next4us-ti/"}