[WordPress] 投稿済ã¿ã®è¨˜äº‹å†…容を一括ã§æ›¸ãæ›ãˆã‚‹æ–¹æ³•WordPressã®æŠ•ç¨¿æ¸ˆã¿ã®è¨˜äº‹å†…容ã«ã€MySQLã‹ã‚‰ä¸€æ‹¬ã§ã‚¯ãƒ©ã‚¹ã‚’付与ã—ãŸã‚Šæ–‡å—列を書ãæ›ãˆãŸã‚Šã™ã‚‹æ–¹æ³•ã§ã™ã€‚SQLæ–‡ã§ç›´æŽ¥æ›¸ãæ›ãˆã‚Œã°ä¸€çž¬ã§è¡Œã†ã“ã¨ãŒã§ãã‚‹ã®ã§ã€è¨˜äº‹æ•°ãŒå¤šãã¦ä¿®æ£ã‚’å…¨ã¦æ‰‹ä½œæ¥ã§è¡Œã†ã“ã¨ãŒé›£ã—ã„時ã«ã¯ã¨ã¦ã‚‚よã„ã§ã™ã€‚ ã©ã“ã«æŠ•ç¨¿ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã„ã‚‹ã‹ WordPressã®æŠ•ç¨¿ãƒ‡ãƒ¼ã‚¿ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã® wp-posts ã¨ã„ã†ãƒ†ãƒ¼ãƒ–ルã«æ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®ãƒ†ãƒ¼ãƒ–ルã«ã¯ã‚¿ã‚¤ãƒˆãƒ«ã‚„更新日時ãªã©ã®æŠ•ç¨¿è¨˜äº‹ã«é–¢ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãŒã„ã‚ã„ã‚å…¥ã£ã¦ãŠã‚Šã€è¨˜äº‹å†…容（コンテンツ部分）ã¯ã“ã®ãƒ†ãƒ¼ãƒ–ル内㮠post_content ã¨ã„ã†ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã«æ ¼ç´ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã“ã«ã¯æŠ•ç¨¿è¨˜äº‹ã®ä»–ã«å›ºå®šãƒšãƒ¼ã‚¸ã‚„リビジョンデータも一緒ã«å…¥ã£ã¦ã„ã¾ã™ã€‚ データを上書ãã™ã‚‹SQLæ–‡ SQLã®ãƒ‡ãƒ¼ã‚¿ã‚’変更ã™ã‚‹ã«ã¯UPDATE文を使用ã—ã¾ã™ã€‚構文ã¯ä»¥ä¸‹ã®ã‚ˆã†ãªå½¢ã§ã™ã€‚ UPDATE テーブルå SET フィールドå=書
![[WordPress] 投稿済ã¿ã®è¨˜äº‹å†…容を一括ã§æ›¸ãæ›ãˆã‚‹æ–¹æ³•](https://cdn-ak-scissors.b.st-hatena.com/image/square/c3bb6aae09e399a2456c543a9a9f759a0b016d30/height=288;version=1;width=512/https%3A%2F%2Fmemocarilog.info%2Fwp-content%2Fuploads%2F2013%2F05%2Fmysql.png)
[WordPress] 投稿記事内ã®æ–‡å—列をSQLæ–‡ã§ä¸€æ‹¬ç½®æ›![[WordPress] 投稿記事内ã®æ–‡å—列をSQLæ–‡ã§ä¸€æ‹¬ç½®æ›](https://cdn-ak-scissors.b.st-hatena.com/image/square/2193540f58a4e6efbb5fbb2539826c5acf414768/height=288;version=1;width=512/http%3A%2F%2Fsyake-labo.com%2Fblog%2Fwp-content%2Fuploads%2F2013%2F11%2Fwordpress-sql-thumbnail.jpg)
{{#tags}}- {{label}}
{{/tags}}