{"action":"created","issue":{"url":"https://api.github.com/repos/mfham/QandA/issues/10","repository_url":"https://api.github.com/repos/mfham/QandA","labels_url":"https://api.github.com/repos/mfham/QandA/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/mfham/QandA/issues/10/comments","events_url":"https://api.github.com/repos/mfham/QandA/issues/10/events","html_url":"https://github.com/mfham/QandA/issues/10","id":308620396,"number":10,"title":"AUTO_INCREMENTテーブルクイズ","user":{"login":"mfham","id":5296052,"avatar_url":"https://avatars3.githubusercontent.com/u/5296052?v=4","gravatar_id":"","url":"https://api.github.com/users/mfham","html_url":"https://github.com/mfham","followers_url":"https://api.github.com/users/mfham/followers","following_url":"https://api.github.com/users/mfham/following{/other_user}","gists_url":"https://api.github.com/users/mfham/gists{/gist_id}","starred_url":"https://api.github.com/users/mfham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfham/subscriptions","organizations_url":"https://api.github.com/users/mfham/orgs","repos_url":"https://api.github.com/users/mfham/repos","events_url":"https://api.github.com/users/mfham/events{/privacy}","received_events_url":"https://api.github.com/users/mfham/received_events","type":"User","site_admin":false},"labels":[{"id":872354669,"url":"https://api.github.com/repos/mfham/QandA/labels/MySQL","name":"MySQL","color":"4dcc86","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-03-26T15:26:36Z","updated_at":"2018-03-26T15:54:54Z","closed_at":null,"author_association":"OWNER","body":""},"comment":{"url":"https://api.github.com/repos/mfham/QandA/issues/comments/376216546","html_url":"https://github.com/mfham/QandA/issues/10#issuecomment-376216546","issue_url":"https://api.github.com/repos/mfham/QandA/issues/10","id":376216546,"user":{"login":"mfham","id":5296052,"avatar_url":"https://avatars3.githubusercontent.com/u/5296052?v=4","gravatar_id":"","url":"https://api.github.com/users/mfham","html_url":"https://github.com/mfham","followers_url":"https://api.github.com/users/mfham/followers","following_url":"https://api.github.com/users/mfham/following{/other_user}","gists_url":"https://api.github.com/users/mfham/gists{/gist_id}","starred_url":"https://api.github.com/users/mfham/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mfham/subscriptions","organizations_url":"https://api.github.com/users/mfham/orgs","repos_url":"https://api.github.com/users/mfham/repos","events_url":"https://api.github.com/users/mfham/events{/privacy}","received_events_url":"https://api.github.com/users/mfham/received_events","type":"User","site_admin":false},"created_at":"2018-03-26T15:54:54Z","updated_at":"2018-03-26T15:54:54Z","author_association":"OWNER","body":"# MySQL 5.7\r\n# innodb_autoinc_lock_mode = 1 (デフォルト)\r\n\r\nDROP TABLE IF EXISTS test.sample;\r\nCREATE TABLE test.sample (\r\n  id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,\r\n  name VARCHAR(50),\r\n  point INT,\r\n  UNIQUE(name)\r\n);\r\nINSERT INTO test.sample (id, name, point) VALUES (NULL, 'foo', 1);\r\n\r\nSELECT * FROM test.sample;\r\n#\tid\tname\tpoint\r\n1\t1\tfoo\t1"}}
{"actor":{"display_login":"mfham"}}