Shulou(Shulou.com)06/02 Report--

This article will explain in detail how to write the SQL sentence about Wordpress modifying the ID of an article. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

What is the SQL statement for Wordpress to modify an article ID?

A few days ago, when I was writing an article, ID jumped directly from 146to 148PowerPress. ID is automatically continuous. The following is to share with you how to change the article ID 148into 147WordPress. Friends who have similar problems can refer to it.

The article was updated in April, and the article ID stayed at 146. in May, I was busy with the exam and did not write a single article. As a result, when I wrote the article in the first few days of June, ID jumped directly from 146to 148. for some reason, my Wordpress has been processed and ID will be continuous automatically. Open the database and change the article ID from 148to 147. the complete SQL statement is as follows:

The code is as follows:

Update wp_posts set id = 147where id = 148; update wp_term_relationships set object_id = 147where object_id = 148; update wp_postmeta set post_id = 147where post_id = 148; update wp_comments set comment_post_ID = 147where comment_post_ID = 148; about Wordpress modifying an article how to write the SQL sentence of ID is shared here. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.