--导入各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行
【版權聲明】