从数据库删除数据之后,前台页面垃圾数据怎么处理

aws_posts_index 删除这个表中的废数据

delete from aws_posts_index where post_type = 'article' and post_id not in (select id from aws_article);

delete from aws_posts_index where post_type = 'question' and post_id not in (select question_id from aws_question);

维护 2021-02-04 00:11:26 通过 网页 浏览(27)

评论已关闭!