\u958b\u59cb<\/p>\n
mysql -u \u30e6\u30fc\u30b6\u540d -p<\/pre>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u89a7<\/p>\n
show databases;<\/pre>\n\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u9078\u629e<\/p>\n
use \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9;<\/pre>\n\u30c6\u30fc\u30d6\u30eb\u306e\u4e00\u89a7<\/p>\n
show tables;<\/pre>\n\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u8868\u793a<\/p>\n
select * from \u30c6\u30fc\u30d6\u30eb;<\/pre>\n\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u524a\u9664<\/p>\n
drop table \u30c6\u30fc\u30d6\u30eb;<\/pre>\n\u5225\u30d5\u30a1\u30a4\u30eb\u306eSQL\u6587\u3092\u6d41\u3057\u8fbc\u3080<\/p>\n
mysql --user=\u30e6\u30fc\u30b6 --database=\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 < \u30d5\u30a1\u30a4\u30eb.sql<\/pre>\n\u30ec\u30b3\u30fc\u30c9\u3092\u66f4\u65b0\u3059\u308b<\/p>\n
update \u30c6\u30fc\u30d6\u30eb set hoge='foo' where \u6761\u4ef6;<\/pre>\n\u30ec\u30b3\u30fc\u30c9\u3092\u524a\u9664\u3059\u308b<\/p>\n
delete from \u30c6\u30fc\u30d6\u30eb where \u6761\u4ef6;<\/pre>\n\u30ab\u30e9\u30e0\u306e\u4e00\u89a7\u3092\u8868\u793a\u3059\u308b<\/p>\n
show columns from \u30c6\u30fc\u30d6\u30eb;<\/pre>\n\u30ab\u30e9\u30e0\u3092\u8ffd\u52a0\u3059\u308b<\/p>\n
alter table \u30c6\u30fc\u30d6\u30eb add \u30ab\u30e9\u30e0\u540d \u578b;<\/pre>\n\u30ab\u30e9\u30e0\u3092\u7279\u5b9a\u30ab\u30e9\u30e0\u306e\u5f8c\u306b\u8ffd\u52a0\u3059\u308b<\/p>\n
alter table \u30c6\u30fc\u30d6\u30eb add \u30ab\u30e9\u30e0\u540d \u578b after \u7279\u5b9a\u30ab\u30e9\u30e0;<\/pre>\n","protected":false},"excerpt":{"rendered":"\u958b\u59cb mysql -u \u30e6\u30fc\u30b6\u540d -p \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u89a7 show databases; \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u9078\u629e use \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9; \u30c6\u30fc\u30d6\u30eb\u306e\u4e00\u89a7 show tables; \u3042\u308b\u30c6\u30fc\u30d6\u30eb\u306e\u5168\u8868\u793a select * f […]<\/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],"tags":[],"class_list":["post-53","post","type-post","status-publish","format-standard","hentry","category-memo"],"_links":{"self":[{"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/53","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=53"}],"version-history":[{"count":15,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions"}],"predecessor-version":[{"id":85,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/53\/revisions\/85"}],"wp:attachment":[{"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=53"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=53"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chitora.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=53"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}