--导入各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行
【版權聲明】
本文爲原創,遵循CC 4.0 BY-SA版權協議!轉載時請附上原文鏈接及本聲明。
原文鏈接:https://tdlib.com/am.php?t=apaNje20muk8 Tag: ZBlog导入