--导入各blog记录统计:
YOYO:142-506=365条,日志:507
JPNV:508-602=95条,日志:603
TTT:1146-1701=556,日志:1702
--更新各记录,添加各自标签:
update hy_thread set title=concat(title," YOYOBLOG")
--select * from hy_thread
where tid between 142 and 506
and instr(title,"|")>0
--365行都有
update hy_thread set title=concat(title," JPNVBLOG")
select * from hy_thread
where tid between 508 and 602
and instr(title,"|")>0
--95行
update hy_thread set title=concat(title," TTTBLOG")
select * from hy_thread
where tid between 1146 and 1701
and instr(title,"|")>0
--556行
Tag: ZBlog导入