{"id":243,"date":"2016-10-04T04:00:58","date_gmt":"2016-10-03T19:00:58","guid":{"rendered":"http:\/\/okamurax.com\/?p=243"},"modified":"2021-07-30T20:25:29","modified_gmt":"2021-07-30T11:25:29","slug":"sql%e3%83%a1%e3%83%a2","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=243","title":{"rendered":"MySQL alter\u3001select\u8a55\u4fa1\u9806"},"content":{"rendered":"<p>\u30fb\u6e96\u5099<\/p>\n<p><span style=\"color: #0000ff;\">create database DB character set utf8;<\/span><\/p>\n<p><span style=\"color: #0000ff;\">use DB;<\/span><\/p>\n<p><span style=\"color: #0000ff;\">drop table if exists TABLE1;<\/span><br \/>\n<span style=\"color: #0000ff;\">create table TABLE1(<\/span><br \/>\n<span style=\"color: #0000ff;\">id int primary key auto_increment not null,<\/span><br \/>\n<span style=\"color: #0000ff;\">name varchar(255)<\/span><br \/>\n<span style=\"color: #0000ff;\">) default character set=utf8<\/span><\/p>\n<p>\u30fbAlter<\/p>\n<p>\u30c6\u30fc\u30d6\u30eb\u306e\u30ea\u30cd\u30fc\u30e0<br \/>\n<span style=\"color: #0000ff;\">alter table TABLE1 rename TABLE2;<\/span><\/p>\n<p>\u5217\u306e\u8ffd\u52a0<br \/>\n<span style=\"color: #0000ff;\">alter table TABLE2 add column NAME2 varchar(255);<\/span><\/p>\n<p>\u5217\u306e\u5909\u66f4<br \/>\n<span style=\"color: #0000ff;\">alter table TABLE2 change NAME2 NAME3 int;<\/span><\/p>\n<p>\u5217\u306e\u524a\u9664<br \/>\n<span style=\"color: #0000ff;\">alter table TABLE2 drop NAME3;<\/span><\/p>\n<p>\u4f5c\u6210\u6e08\u307f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u5909\u66f4<br \/>\n<span style=\"color: #0000ff;\">alter database DB character set utf8;<\/span><\/p>\n<p>\u5236\u7d04\u306e\u8ffd\u52a0\u65b9\u6cd5<br \/>\n<span style=\"color: #0000ff;\">alter table TABLE1 add unique (NAME);<\/span><\/p>\n<p>\u3061\u306a\u307f\u306b\u3001primary\u3068unique\u306f\u8907\u6570\u6307\u5b9a\u3059\u308b\u3068\u3001\u8907\u5408\u306b\u306a\u308b\u306e\u3067unique\u3092\u305d\u308c\u305e\u308c\u8907\u6570\u306e\u5217\u306e\u5834\u5408\u3001<br \/>\ncreate table tbl (id int ,nm varchar(5) , unique(id) , unique(nm));<br \/>\n\u306e\u3088\u3046\u306b\u6307\u5b9a\u3002<\/p>\n<p>\u30fb\u5236\u7d04\u306e\u7a2e\u985e<\/p>\n<p>not null<br \/>\ncheck<br \/>\nunique key<br \/>\nprimary key<br \/>\nforeign key<\/p>\n<p>\u30fbselect\u5f0f\u306e\u8a55\u4fa1\u9806<\/p>\n<p>from<br \/>\non &#8211;\u00a0join<br \/>\nwhere<br \/>\ngroup by<br \/>\nhaving<br \/>\nselect<br \/>\ndistinct<br \/>\norder by<br \/>\ntop(limit)<\/p>\n<p>\u30fb\u6587\u5b57\u5217\u578b<\/p>\n<p>https:\/\/dev.mysql.com\/doc\/refman\/8.0\/ja\/char.html<\/p>\n<p><span style=\"color: #0000ff;\">char(n)<\/span><br \/>\n\u56fa\u5b9a\u9577\u3067\u3001\u53f3\u5074\u306b\u30b9\u30da\u30fc\u30b9\u304c\u57cb\u3081\u3089\u308c\u308b\u3002<\/p>\n<p><span style=\"color: #0000ff;\">varchar(n)<\/span><br \/>\n\u53ef\u5909\u9577\u3001255\u3092\u8d85\u3048\u3066n\u3092\u6307\u5b9a\u3059\u308b\u3068\u30d7\u30ea\u30d5\u30a3\u30c3\u30af\u30b9\u304c2\u30d0\u30a4\u30c8\u3068\u306a\u308b\u3002\u30d7\u30ea\u30d5\u30a3\u30c3\u30af\u30b9\u683c\u7d0d\u3055\u308c\u305f\u30c7\u30fc\u30bf\u306b\u5bfe\u3059\u308b\u30b9\u30c8\u30ec\u30fc\u30b8\u3068\u306f\u5225\u3002\u30b9\u30c8\u30ec\u30fc\u30b8\u306b\u3064\u3044\u3066\u306ftext\u3082varchar\u3082\u4fdd\u5b58\u3057\u305f\u5bb9\u91cf\u306e\u307f\u3002<\/p>\n<p>\u4e21\u65b9\u3068\u3082\u3001n\u306f\u30d0\u30a4\u30c8\u3067\u306f\u306a\u304f\u6587\u5b57\u6570\u3002\u307e\u305f\u3001MyISAM\u3068InnoDB\u3067\u306e\u9055\u3044\u304c\u3042\u308b\u306e\u3067\u3001\u6ce8\u610f\u30025.5\u672a\u6e80\u306fMyISAM\u30015.5\u4ee5\u964d\u306fInnoDB<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30fb\u6e96\u5099 create database DB character set utf8; use DB; drop table if exists TABLE1; create table TABLE1( id int pr &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/appbay.org\/?p=243\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MySQL alter\u3001select\u8a55\u4fa1\u9806&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,89],"class_list":["post-243","post","type-post","status-publish","format-standard","hentry","category-1","tag-mysql-mariadb","tag-sql"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=243"}],"version-history":[{"count":33,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":4449,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/243\/revisions\/4449"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}