[SQL] dedecms转wordpress 分类更新

sql

insert INTO wp_vulsee.wp_term_relationships select dedecmsdb.dede_archives.id, ( select wp_anyun_org.wp_terms.term_id from wp_anyun_org.wp_terms where wp_anyun_org.wp_terms.name= (select dedecmsdb.dede_arctype.typename from dedecmsdb.dede_arctype where dedecmsdb.dede_arctype.id=dedecmsdb.dede_archives.typeid) ),'0' from dedecmsdb.dede_archives where dedecmsdb.dede_archives.id not in (9715,9714)