{"id":675,"date":"2014-08-29T21:53:38","date_gmt":"2014-08-29T12:53:38","guid":{"rendered":"http:\/\/androiphone.uvs.jp\/?p=675"},"modified":"2015-11-09T13:48:38","modified_gmt":"2015-11-09T04:48:38","slug":"sqlite-%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e3%82%b9%e3%82%ad%e3%83%bc%e3%83%9e%e3%81%ae%e8%a8%82%e6%ad%a3","status":"publish","type":"post","link":"https:\/\/androiphone.uvs.jp\/?p=675","title":{"rendered":"[SQLite] \u30c6\u30fc\u30d6\u30eb\u30b9\u30ad\u30fc\u30de\u306e\u8a02\u6b63"},"content":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u30b9\u30ad\u30fc\u30de\u3092\u5f8c\u304b\u3089\u8a02\u6b63\u3057\u305f\u5834\u5408\u3001MySQL\u3067\u306fALTER TABLE\u6587\u3067\u51fa\u6765\u308b\u306e\u3067 SQLite\u3067\u3082ALTER TABLE\u6587\u3092\u6295\u3052\u307f\u305f\u304c\u30fb\u30fb\u30fb\u5909\u66f4\u3055\u308c\u306a\u3044\u3002\u3002\u3002\u3002<\/p>\n<p>\u307e\u305f\u3001\u3044\u308d\u3044\u308d\u8abf\u3079\u3066\u307f\u305f\u3089<\/p>\n<p><a href=\"http:\/\/d.hatena.ne.jp\/cesar\/20070417\/p1\">http:\/\/d.hatena.ne.jp\/cesar\/20070417\/p1<\/a><\/p>\n<p>\u306a\u3093\u3068\u30fb\u30fb\u30fb<strong>\u300c\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u5909\u66f4\u3068\u30ab\u30e9\u30e0\u306e\u8ffd\u52a0\u3057\u304b\u3067\u304d\u307e\u305b\u3093\u3002\u306a\u306b\u3088\u308a\u30d0\u30fc\u30b8\u30e7\u30f33.1.3\u3067\u306e\u5b9f\u88c5\u306e\u3088\u3046\u3067\u3059\u300d<\/strong> \u3068\u30fb\u30fb\u30fb\u3002<\/p>\n<p>SQLite Database\u30d6\u30e9\u30a6\u30b6\u3067\u3082\u78ba\u304b\u306b\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u306e\u5909\u66f4\u3068\u30ab\u30e9\u30e0\u306e\u8ffd\u52a0(\u3057\u304b\u3082\u5f8c\u4ed8\u306e\u307f)\u3057\u304b\u3067\u304d\u307e\u305b\u3093\u3002 \u8a02\u6b63\u3059\u308b\u306b\u306f\u3001\u5225\u306a\u30c6\u30fc\u30d6\u30eb\u3092\u4e00\u6642\u7684\u306a\u540d\u524d\u3067\u3064\u304f\u308a\u3001\u305d\u3053\u306b \u524d\u306e\u30c6\u30fc\u30d6\u30eb:table_b \u5f8c\u306e\u30c6\u30fc\u30d6\u30eb:table_a<\/p>\n<p>&nbsp;<\/p>\n<pre>[sql]\r\nINSERT INTO table_a SELECT * FROM table_b;\r\n[\/sql]<\/pre>\n<p>&nbsp;<\/p>\n<p>\u3057\u3066\u3001table_b\u3092\u6d88\u3057\u3066table_a\u3092table_b\u306b\u30c6\u30fc\u30d7\u540d\u5909\u66f4\u3059\u308b\u3068\u3044\u3046\u3001\u3081\u3093\u3069\u304f\u3055\u3055\u30fb\u30fb\u30fb<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30c6\u30fc\u30d6\u30eb\u30b9\u30ad\u30fc\u30de\u3092\u5f8c\u304b\u3089\u8a02\u6b63\u3057\u305f\u5834\u5408\u3001MySQL\u3067\u306fALTER TABLE\u6587\u3067\u51fa\u6765\u308b\u306e\u3067 SQLite\u3067\u3082ALTER TABLE\u6587\u3092\u6295\u3052\u307f\u305f\u304c\u30fb\u30fb\u30fb\u5909\u66f4\u3055\u308c\u306a\u3044\u3002\u3002\u3002\u3002 \u307e\u305f\u3001\u3044\u308d\u3044\u308d\u8abf\u3079\u3066\u307f\u305f\u3089 http:\/\/d.ha [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"","_original_post":"","footnotes":""},"categories":[18,17],"tags":[],"class_list":["post-675","post","type-post","status-publish","format-standard","hentry","category-html","category-sqlite","ja"],"_links":{"self":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=675"}],"version-history":[{"count":8,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/675\/revisions"}],"predecessor-version":[{"id":904,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=\/wp\/v2\/posts\/675\/revisions\/904"}],"wp:attachment":[{"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/androiphone.uvs.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}