{"id":914,"date":"2021-10-15T03:02:58","date_gmt":"2021-10-14T18:02:58","guid":{"rendered":"https:\/\/suzutukiblog.com\/?p=914"},"modified":"2022-10-08T00:30:57","modified_gmt":"2022-10-07T15:30:57","slug":"mysql18","status":"publish","type":"post","link":"https:\/\/suzutukiblog.com\/index.php\/2021\/10\/15\/mysql18\/","title":{"rendered":"MySQL(\u305d\u306e18 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u306e\u64cd\u4f5c)"},"content":{"rendered":"

\u305d\u306e17\u304b\u3089\u7d9a\u304d\u307e\u3059\u3002<\/a><\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u306e\u64cd\u4f5c\u306b\u304a\u3051\u308b \u6ce8\u610f\u70b9\u306b\u3064\u3044\u3066<\/h3>\n

alter table, <\/strong>drop table, <\/strong>drop database<\/strong>\u7b49<\/p>\n

\u30fb\u64cd\u4f5c\u306f\u57fa\u672c\u7684\u306b\u306f\u53d6\u308a\u6d88\u305b\u306a\u3044<\/strong>
\n\u30fb\u7279\u306b\u5b9f\u52d9\u306b\u304a\u3044\u3066\u672c\u756a\u74b0\u5883\u3092\u64cd\u4f5c\u3059\u308b\u3068\u304d\u306f\u30b5\u30fc\u30d3\u30b9\u3092\u30e1\u30f3\u30c6\u30ca\u30f3\u30b9\u30e2\u30fc\u30c9\u306b\u3057\u3066\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3092\u53d6\u3063\u3066\u304b\u3089alter table\u306a\u3069\u3092\u5b9f\u884c\u3059\u308b\u306e\u304c\u5b89\u5168
\n\u30fb\u60f3\u5b9a\u5916\u306b\u6642\u9593\u304c\u304b\u304b\u308a\u30b7\u30b9\u30c6\u30e0\u30c8\u30e9\u30d6\u30eb<\/strong>\u306b\u306a\u308b\u5834\u5408\u304c\u3042\u308b\u306e\u3067\u6ce8\u610f\uff01
\n\u30fb\u30c6\u30b9\u30c8\u74b0\u5883\u3067alter table\u306a\u3069\u306e\u30c6\u30b9\u30c8\u3092\u3057\u3066\u554f\u984c\u70b9\u3092\u6d17\u3044\u51fa\u3057\u3066\u304b\u3089
\n\u672c\u756a\u74b0\u5883\u3067\u5b9f\u884c\u3059\u308b\u306e\u304c\u30aa\u30b9\u30b9\u30e1<\/p>\n

\u4f8b\uff1a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210book_store\u3068\u3044\u3046\u540d\u524d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/span><\/h3>\n

<\/p>\n

create database<\/strong> book_store;<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u78ba\u8a8d\u3059\u308b<\/p>\n

show databases;<\/p>\n

\"\"<\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u547d\u540d\u30eb\u30fc\u30eb\u306b\u3064\u3044\u3066<\/h3>\n

\u30eb\u30fc\u30eb\u306b\u5f93\u308f\u306a\u3044\u3068\u30a8\u30e9\u30fc<\/strong>\u306b\u306a\u308b<\/p>\n

\u6700\u521d\u306f\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3067\u30a2\u30f3\u30c0\u30fc\u30b9\u30b3\u30a2\u3084\u6570\u5b57\u306f\u30c0\u30e1
\n\u534a\u89d2\u306e\u30a2\u30eb\u30d5\u30a1\u30d9\u30c3\u30c8\u3067\u59cb\u3081\u308b
\nmydb3\u306a\u3069\u3064\u3051\u305f\u4eba\u3057\u304b\u308f\u304b\u3089\u306a\u3044\u30de\u30b8\u30c3\u30af\u30ca\u30f3\u30d0\u30fc<\/strong>\u306f\u907f\u3051\u3088\u3046<\/p>\n

\u4f8b2\uff1abooks\u3068\u3044\u3046\u540d\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u305f\u3044\uff01<\/h3>\n
use book_store;\r\ncreate table<\/strong> books\r\n(id int not null auto_increment primary key, title varchar(255) not null);<\/pre>\n
\u30c6\u30fc\u30d6\u30eb
\nshow tables;
\nshow columns from books;<\/p>\n
\"\"<\/p>\n
(id int not null auto_increment primary key, title varchar(255) not null);<\/p>\n
\u2191\u306e\u610f\u5473\u306b\u3064\u3044\u3066<\/p>\n
id\u306e\u4f5c\u6210\u306b\u3064\u3044\u3066int\u3067\u30c7\u30fc\u30bf\u578b\u3092\u6574\u6570\u578b<\/strong>\u306b\u8a2d\u5b9a
\nnot null<\/strong> \u3067null\u3092\u8a31\u53ef\u3057\u306a\u3044<\/strong>\u3068\u3044\u3046\u610f\u5473
\nauto increment<\/strong>\u3067id\u3092\u81ea\u52d5\u7684\u306b\u3075\u308b\u6307\u5b9a
\nprimary key<\/strong>\u4e3b\u30ad\u30fc\u306e\u8a2d\u5b9aid\u3092\u4e3b\u30ad\u30fc<\/strong>\u306b\u3059\u308b\u3068\u3044\u3046\u8a2d\u5b9a
\n\u30bf\u30a4\u30c8\u30eb\u306b\u3064\u3044\u3066
\nvarchar(255)<\/strong>\u306f\u6700\u5927255\u6587\u5b57\u306e\u53ef\u5909\u9577\u6587\u5b57\u5217\u578b<\/strong>\u3092\u6307\u5b9a
\nnot null<\/strong>\u306fnull\u3092\u8a31\u53ef\u3057\u306a\u3044
\n\u3068\u3044\u3046\u610f\u5473<\/p>\n
\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u306e\u5909\u66f4<\/h3>\n
\u4f8b3\uff1a\u66f8\u7c4d\u3092\u7ba1\u7406\u3059\u308bbooks\u30c6\u30fc\u30d6\u30eb\u306b\u4fa1\u683c\u3092\u7ba1\u7406\u3059\u308b\u5217\u3092\u8ffd\u52a0\u3057\u305f\u3044\uff01(\u5217\u540d\u306f price \u30c7\u30fc\u30bf\u578b\u306f int \u3068\u3057\u3066\u8ffd\u52a0)<\/h3>\n
alter table books add price int after id;<\/strong><\/pre>\n
\u4f8b4\uff1a\u5217\u540dprice\u3092unit_price\u306b\u5909\u66f4\u3057\u305f\u3044
\n\u69cb\u6587:alter table \u30c6\u30fc\u30d6\u30eb\u540d change \u65e7\u5217\u540d \u65b0\u5217\u540d \u30c7\u30fc\u30bf\u578b<\/h3>\n
alter table books change price unit_price int;\r\nshow columns from books;<\/strong><\/pre>\n
\"\"<\/p>\n
\u4f8b5\uff1abooks\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u5217unit_price\u3092\u524a\u9664
\n\u69cb\u6587:alter table \u30c6\u30fc\u30d6\u30eb\u540d drop \u5217\u540d;<\/h3>\n
alter table books drop unit_price;\r\n\r\nshow columns from books;<\/strong><\/pre>\n
\"\"<\/p>\n
 <\/p>\n
\u4f8b6\uff1abooks\u30c6\u30fc\u30d6\u30eb\u3092\u524a\u9664
\n\u69cb\u6587:drop table \u524a\u9664\u3057\u305f\u3044\u30c6\u30fc\u30d6\u30eb\u540d<\/h3>\n
drop table books;<\/strong><\/pre>\n
\u524a\u9664\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306f \u57fa\u672c\u7684\u306b\u306f\u7c21\u5358\u306b\u5fa9\u65e7\u3067\u304d\u306a\u3044\u306e\u3067\u6ce8\u610f!<\/strong><\/p>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u524a\u9664<\/h3>\n
\u4f8b7\uff1abook_store \u3092\u524a\u9664\u3059\u308b(drop database)<\/h3>\n
drop database book_store;<\/strong><\/pre>\n
\"\"<\/p>\n
\u524a\u9664\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u57fa\u672c\u7684\u306b\u306f\u7c21\u5358\u306b\u5fa9\u65e7\u3067\u304d\u306a\u3044\u306e\u3067\u6ce8\u610f\uff01<\/strong><\/p>\n
\u305d\u306e19\u306b\u7d9a\u304d\u307e\u3059\u3002<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u305d\u306e17\u304b\u3089\u7d9a\u304d\u307e\u3059\u3002 \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u306e\u64cd\u4f5c\u306b\u304a\u3051\u308b \u6ce8\u610f\u70b9\u306b\u3064\u3044\u3066 alter table, drop table, drop database\u7b49 \u30fb\u64cd\u4f5c\u306f\u57fa\u672c\u7684\u306b\u306f\u53d6\u308a\u6d88\u305b\u306a\u3044 \u30fb\u7279\u306b\u5b9f\u52d9\u306b\u304a\u3044\u3066\u672c\u756a\u74b0\u5883\u3092\u64cd\u4f5c\u3059\u308b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,27],"tags":[],"class_list":["post-914","post","type-post","status-publish","format-standard","hentry","category-mysql","category-programming-note"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t