{"id":6103,"date":"2021-02-14T11:49:17","date_gmt":"2021-02-14T02:49:17","guid":{"rendered":"https:\/\/nsme.red\/wp\/?p=6103"},"modified":"2021-02-14T11:49:45","modified_gmt":"2021-02-14T02:49:45","slug":"%e3%82%ab%e3%83%a9%e3%83%a0%e8%bf%bd%e5%8a%a0%e3%80%80alter-table","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e6%93%8d%e4%bd%9c\/6103\/","title":{"rendered":"\u30ab\u30e9\u30e0\u8ffd\u52a0\u3000ALTER TABLE"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>alter table \n\t\u30c6\u30fc\u30d6\u30eb\u540d \nadd \n\t\u30ab\u30e9\u30e0\u540d\n\t\u30c7\u30fc\u30bf\u578b\n\tNULL\u8a31\u53ef\n\tDEFAULT \u30c7\u30d5\u30a9\u30eb\u30c8\u5024\n\tCOMMENT \u30b3\u30e1\u30f3\u30c8\n\t\u30ad\u30fc\u6307\u5b9a\nfirst\/after \u30ab\u30e9\u30e0\u4f4d\u7f6e\u306e\u6307\u5b9a<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f8b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLE wp_saiyou \n  add check1 BOOLEAN COMMENT '\u51fa\u52e4\u78ba\u8a8d',\n  add etc1 TEXT NULL COMMENT '\u5099\u8003',\n  add checker1 varchar(40) NULL COMMENT '\u78ba\u8a8d\u8005'<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4f8b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[43],"tags":[],"class_list":["post-6103","post","type-post","status-publish","format-standard","hentry","category-43"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=6103"}],"version-history":[{"count":2,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6103\/revisions"}],"predecessor-version":[{"id":6105,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6103\/revisions\/6105"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=6103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=6103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=6103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}