deletefrom wp_users where ID notin
(select user_id from wp_usermeta where meta_key ='wp_capabilities')
select user_id from wp_usermeta where user_id notin
(select ID from wp_users)
- lord_viper
1
1非常好,谢谢您!我相信您的第二个查询应该是说DELETE。DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID from wp_users); - contrid