Allen 2020-06-04 16:31:40 27447 0 0 0 0

--导入各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导入
相关内容

JPNV导入完成 2020-06-03 

YOYO Blog导入完成 2020-06-03 

TTT BLOG导入完成 2020-06-03 

欢迎评论
未登录,
请先 [ 注册 ] or [ 登录 ]
(一分钟即可完成注册!)
返回首页     ·   返回[站点日志]   ·   返回顶部