WP常用MySQL語法

刪除所有修改中產生的備份文章

DELETE FROM wp_posts WHERE post_type = "revision";

刪除所有垃圾、未核准的迴響

DELETE from wp_comments WHERE comment_approved = '0';

修改文章所有作者

UPDATE wp_posts SET post_author=new_user WHERE post_author=old_user;

變更密碼

UPDATE wp_users SET user_pass = MD5('123456') WHERE wp_users.user_login = 'coolsea' LIMIT 1;
0 回復

發表評論

Want to join the discussion?
Feel free to contribute!

發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *