· 8 years ago · May 09, 2018, 09:28 AM
1CREATE TABLE IF NOT EXISTS wp_temporary AS (SELECT * FROM wp_term_taxonomy WHERE `wp_term_taxonomy`.`taxonomy` = 'portfolio_entries')
2
3UPDATE `wp_temporary` SET `term_taxonomy_id`= `term_taxonomy_id` + 1000, `taxonomy`= 'post_tag' WHERE `taxonomy`= 'portfolio_entries'
4
5INSERT INTO `wp_term_taxonomy`(`term_taxonomy_id`, `term_id`, `taxonomy`, `description`, `parent`, `count`) SELECT * FROM wp_temporary
6
7DROP TABLE wp_temporary