TTT BLOG > 站点日志
ZBlog导入总结,并给每个帖子上加标签|ZBlog导入
Allen   ·  2020.0604 16:31:40
Stat:5637v. 0r. 0u. 0d. 0f 
#0. (Normal)

--导入各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://taoyoyo.net/am.php?t=apaNje20muk8

Tag:   ZBlog导入
前一个  ·   下一个
【相关内容】
顶部     1/1 
未登录,请先 [注册] or [登录]
(一分钟即可完成注册!)
Copyright ©TTT BLOG, All Rights Reserved.
Powered by TYCMS Version 1002