MySQL
- 106 ответов
- 0 вопросов
62
Вклад в тег
-- Cleaning wp_commentmeta
SELECT *
FROM wp_commentmeta
WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
DELETE FROM wp_commentmeta
WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
SELECT *
FROM wp_commentmeta
WHERE meta_key LIKE '%akismet%';
DELETE FROM wp_commentmeta
WHERE meta_key LIKE '%akismet%';
-- Cleaning wp_postmeta table
SELECT *
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL;
=FILTER(A1:A11;ISNA(MATCH(A1:A11;B1:B12;0)))=FILTER(B1:B12;ISNA(MATCH(B1:B12;A1:A11;0)))
Select the files you want to extract in the WinRAR window. Right click on them. Choose "Extract to Specified Folder". Choose the folder you want them to end up in. WinRAR bypasses the temp folder and dumps everything immediately into the folder you choose.
