Trying to delete multiple wp multisite tables in phpmyadmin
delete all tables belonging to site id 73 (currently there are 9 tables)
i can identify the tables as wp_73_commentmeta, wp_73_comments, etc etc
Entered the code below in the SQL tab of phpmyadmin
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = 'istheplaDBbb9h3' AND table_name LIKE 'wp_73_%';
and clicked Go
the code appears to be accepted and while the tables appear to be identified nothing happens as no rows (0-0) are deleted
see template image of result at http://i.imgur.com/sjoVP0J.png
Obviously I am omitting something or am in the wrong tab!
Any help at all much appreciated
- The topic ‘Multisite phpmyadmin-delete multiple tables with prefix wp_xx_’ is closed to new replies.