{"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":"

\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
\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
\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
\n\u305d\u3093\u306a\u3053\u3068\u3092\u8003\u3048\u308b\u3001\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3002<\/p>\n

<\/p>\n

DB\u306e\u69cb\u6210<\/h2>\n

\u672c\u756a\u3068\u30c6\u30b9\u30c8(staging)\u304c\u3042\u308b\u3068\u3059\u308b\u3058\u3083\u308d\u3002<\/p>\n

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

\u30c6\u30fc\u30d6\u30eb<\/h2>\n
\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
\u30c6\u30b9\u30c8\u30c7\u30fc\u30bf<\/p>\n
\r\ninsert into employees (name, email, secret_num) values ("kaiba", "kaiba@kaibacorp.co.jp", 1234);\r\ninsert into employees (name, email, secret_num) values ("waketi", "waketi@kaibacorp.co.jp", 222);\r\ninsert into employees (name, email, secret_num) values ("ematette", "ematette@kaibacorp.co.jp", 123);\r\n<\/pre>\n
\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
\u672c\u756a\u306e\u30c7\u30fc\u30bf\u3092\u30b3\u30d4\u30fc\u3059\u308b<\/h2>\n
\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
\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
\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
\r\nmysqldump -uprod_user -p******* -hhoge_prod my_database | mysql -utest -pTEST -hhoge_stg my_database\r\n<\/pre>\n
\u307e\u305a\u3044\u30c7\u30fc\u30bf\u3092\u30de\u30b9\u30af\u3059\u308b<\/h2>\n
\r\nupdate employees set name=concat("name",id), \r\nemail=concat("dev+",id,"@example.com"), \r\nsecret_num=1111;\r\n<\/pre>\n
\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
\u3084\u3063\u305f\u305c\u3002
\nconcat\u3067id\u3068\u7d50\u5408\u3057\u3066\u3084\u308b\u306e\u304c\u30df\u30bd\u3002<\/p>\n
\u3068\u3044\u3046\u500b\u4eba\u7684\u306a\u30e1\u30e2\u3067\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\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 […]<\/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":[],"aioseo_head":"\n\t\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