{"id":2753,"date":"2016-11-18T00:49:00","date_gmt":"2016-11-17T15:49:00","guid":{"rendered":"http:\/\/pokosho.com\/b\/?p=2753"},"modified":"2016-11-18T00:53:53","modified_gmt":"2016-11-17T15:53:53","slug":"%e6%9c%ac%e7%95%aa%e3%81%ab%e8%bf%91%e3%81%84%e3%83%86%e3%82%b9%e3%83%88%e7%94%a8db%e3%82%92%e7%94%a8%e6%84%8f%e3%81%97%e3%81%9f%e3%81%84","status":"publish","type":"post","link":"https:\/\/pokosho.com\/b\/archives\/2753","title":{"rendered":"\u672c\u756a\u306b\u8fd1\u3044\u30c6\u30b9\u30c8\u7528DB\u3092\u7528\u610f\u3057\u305f\u3044"},"content":{"rendered":"<p>\u672c\u756a\u306eDB\u304c\u3042\u3063\u305f\u3068\u3057\u3066\u3001\u305d\u308c\u306b\u8fd1\u3044\u30c7\u30fc\u30bf\u3067\u30c6\u30b9\u30c8\u3059\u308b\u3053\u3068\u306f\u5927\u5909\u91cd\u8981\uff01<br \/>\n\u672c\u756a\u306a\u3089\u6c17\u3065\u3051\u305f\u306e\u306b\u306a\u301c\uff01\u3068\u3044\u3046\u306e\u304c\u683c\u6bb5\u306b\u6e1b\u308b\u3002<br \/>\n\u3067\u3082\u672c\u756a\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u3066\u4f7f\u3046\u306e\u306f\u6016\u3044\u5834\u5408\u304c\u3042\u3063\u3066(\u4f8b\u3048\u3070\u500b\u4eba\u60c5\u5831)\u3001\u4e07\u304c\u4e00\u304a\u6f0f\u3089\u3057\u3057\u3066\u3082\u554f\u984c\u306e\u306a\u3044\u3088\u3046\u306b\u30de\u30b9\u30ad\u30f3\u30b0\u3057\u3066\u4f7f\u3044\u305f\u3044\u3002<br \/>\n\u305d\u3093\u306a\u3053\u3068\u3092\u8003\u3048\u308b\u3001\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3002<\/p>\n<p><!--more--><\/p>\n<h2>DB\u306e\u69cb\u6210<\/h2>\n<p>\u672c\u756a\u3068\u30c6\u30b9\u30c8(staging)\u304c\u3042\u308b\u3068\u3059\u308b\u3058\u3083\u308d\u3002<\/p>\n<p>hoge_prod \u304c\u672c\u756a\u7528DB\u306e\u30db\u30b9\u30c8\u3001 hoge_stg\u304c\u30c6\u30b9\u30c8\u7528DB\u306e\u30db\u30b9\u30c8\u3058\u3083\u3002<\/p>\n<h2>\u30c6\u30fc\u30d6\u30eb<\/h2>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\ncreate table employees (\r\nid BIGINT NOT NULL AUTO_INCREMENT,\r\nname varchar(100),\r\nemail varchar(100),\r\nsecret_num INT,\r\nPRIMARY KEY (id));\r\n<\/pre>\n<p>\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\ninsert into employees (name, email, secret_num) values (&quot;kaiba&quot;, &quot;kaiba@kaibacorp.co.jp&quot;, 1234);\r\ninsert into employees (name, email, secret_num) values (&quot;waketi&quot;, &quot;waketi@kaibacorp.co.jp&quot;, 222);\r\ninsert into employees (name, email, secret_num) values (&quot;ematette&quot;, &quot;ematette@kaibacorp.co.jp&quot;, 123);\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n+----+----------+--------------------------+------------+\r\n| id | name | email | secret_num |\r\n+----+----------+--------------------------+------------+\r\n| 1 | kaiba | kaiba@kaibacorp.co.jp | 1234 |\r\n| 2 | waketi | waketi@kaibacorp.co.jp | 2222 |\r\n| 3 | ematette | ematette@kaibacorp.co.jp | 123 |\r\n+----+----------+--------------------------+------------+\r\n<\/pre>\n<h2>\u672c\u756a\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3059\u308b<\/h2>\n<p>\u5de8\u5927\u306aDB\u3067\u3042\u308c\u3070\u3001\u30b9\u30ca\u30c3\u30d7\u30b7\u30e7\u30c3\u30c8\u3092\u30b3\u30d4\u30fc\u3057\u3066\u3084\u308b\u306e\u304c\u826f\u3044\u3067\u3059\u304c\u3001mysql\u306euser\u30c6\u30fc\u30d6\u30eb\u3082\u672c\u756a\u306e\u3082\u306e\u306b\u306a\u308b\u306e\u3067\u3001\u30c6\u30b9\u30c8\u7528\u306e\u30e6\u30fc\u30b6\u306b\u3057\u3066\u5909\u66f4\u3057\u76f4\u3059\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<br \/>\n\u5c0f\u3055\u3044DB\u3067\u3042\u308c\u3070mysqldump\u3067\u30c6\u30b9\u30c8\u5bfe\u8c61\u306eDB\u3060\u3051\u4e0a\u66f8\u304d\u3057\u3066\u3084\u308b\u306e\u304c\u697d\u3002<br \/>\n\u672c\u756a\u3092dump\u3057\u3066\u3001\u30c6\u30b9\u30c8\u306b\u6d41\u3059\u3002\u9006\u306b\u3059\u308b\u3068\u6b7b\u306b\u307e\u3059\u3002<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nmysqldump -uprod_user -p******* -hhoge_prod my_database | mysql -utest -pTEST -hhoge_stg my_database\r\n<\/pre>\n<h2>\u307e\u305a\u3044\u30c7\u30fc\u30bf\u3092\u30de\u30b9\u30af\u3059\u308b<\/h2>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nupdate employees set name=concat(&quot;name&quot;,id), \r\nemail=concat(&quot;dev+&quot;,id,&quot;@example.com&quot;), \r\nsecret_num=1111;\r\n<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\n+----+-------------------+-------------------+------------+\r\n| id | name | email | secret_num |\r\n+----+-------------------+-------------------+------------+\r\n| 1 | name1 | dev+1@example.com | 1111 |\r\n| 2 | name2 | dev+2@example.com | 1111 |\r\n| 3 | name3 | dev+3@example.com | 1111 |\r\n+----+-------------------+-------------------+------------+\r\n<\/pre>\n<p>\u3084\u3063\u305f\u305c\u3002<br \/>\nconcat\u3067id\u3068\u7d50\u5408\u3057\u3066\u3084\u308b\u306e\u304c\u30df\u30bd\u3002<\/p>\n<p>\u3068\u3044\u3046\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3067\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u756a\u306eDB\u304c\u3042\u3063\u305f\u3068\u3057\u3066\u3001\u305d\u308c\u306b\u8fd1\u3044\u30c7\u30fc\u30bf\u3067\u30c6\u30b9\u30c8\u3059\u308b\u3053\u3068\u306f\u5927\u5909\u91cd\u8981\uff01 \u672c\u756a\u306a\u3089\u6c17\u3065\u3051\u305f\u306e\u306b\u306a\u301c\uff01\u3068\u3044\u3046\u306e\u304c\u683c\u6bb5\u306b\u6e1b\u308b\u3002 \u3067\u3082\u672c\u756a\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3057\u3066\u4f7f\u3046\u306e\u306f\u6016\u3044\u5834\u5408\u304c\u3042\u3063\u3066(\u4f8b\u3048\u3070\u500b\u4eba\u60c5\u5831)\u3001\u4e07\u304c\u4e00\u304a\u6f0f\u3089\u3057\u3057\u3066\u3082\u554f\u984c\u306e [&hellip;]<\/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":[7],"tags":[],"class_list":["post-2753","post","type-post","status-publish","format-standard","hentry","category-program"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/posts\/2753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/comments?post=2753"}],"version-history":[{"count":0,"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/posts\/2753\/revisions"}],"wp:attachment":[{"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/media?parent=2753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/categories?post=2753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pokosho.com\/b\/wp-json\/wp\/v2\/tags?post=2753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}