Wordpress修改某篇文章ID(把ID为148的改成147)的SQL语句
<p><span style='font-family: tahoma, arial, "Microsoft YaHei"; font-size: 14px;'>4月更新过文章，文章ID停留在146，5月忙于考试，文章一篇都没写，结果6月前几天写文章的时候，ID从146直接跳到148，也不知道什么原因，我的Wordpress是做过处理的ID是会自动连续的。打开数据库，把文章ID为148的改成147，完整的SQL语句如下： </span></p>
<div style='margin: 3px auto 0px; padding: 0px 3px; outline: none; line-height: 21.6px; clear: both; border-width: 1px; border-style: solid; border-color: rgb(0, 153, 204); background: rgb(246, 251, 255); overflow: hidden; font-family: tahoma, arial, "Microsoft YaHei";'>
<p style="margin: 0px; padding: 0px; outline: none; float: right; line-height: 25.2px; font-size: 14px;">
<span style="line-height: 25.2px; cursor: pointer;"><u>复制代码</u></span></p>
<p>
代码如下:</p>
</div>
<p style='margin: 0px auto 3px; padding: 0px 3px; outline: none; line-height: 25.2px; font-size: 14px; clear: both; border-right: 1px solid rgb(0, 153, 204); background: rgb(221, 237, 251); overflow: hidden; border-left: 1px solid rgb(0, 153, 204); word-break: break-all; border-bottom: 1px solid rgb(0, 153, 204); word-wrap: break-word; font-family: tahoma, arial, "Microsoft YaHei";'>
<br>
update wp_posts set id = 147 where id = 148; <br>
update wp_term_relationships set object_id = 147 where object_id = 148; <br>
update wp_postmeta set post_id = 147 where post_id = 148; <br>
update wp_comments set comment_post_ID = 147 where comment_post_ID = 148; </p>
頁:
[1]