Incorrect Comment Count number on main page

after i updated my blog which is powerd by wordpress and deleted all th开发者_StackOverflow社区e comments of my blog. i found a wrong thing. each entry of my blog still shows the previous Comment Count number。but i have delted all the comment of the site by the phpmyadmin. how to make the Comment Count number to zero?

You should also update the comment_count column to 0 in wp_posts table.

This column contains the number of comment associative with the post since you already deleted all the comments hence you should also update this field value to 0

UPDATE wp_posts SET comment_count=0