wordpress利用mysql命令实现文章分类

wordpress如何利用mysql命令实现文章分类，下面web建站小编给大家简单介绍一下具体实现代码！

未分类的文章插入分类

//把文章id=120插入到分类id=2
insert into wp_term_relationships ( object_id, term_taxonomy_id) values ('120', '2');

删除分类ID

//把文章id=120从分类id=2中删除
delete from wp_term_relationships where object_id=120and term_taxonomy_id = 2；

修改文章分类

//把文章id=120从分类id=2改到分类id=3中
update wp_term_relationships set term_taxonomy_id=5 where object_id=120 and term_taxonomy_id = 2;