迅睿CMS-直接进行数据表同步

01.同步已存在数据

UPDATE dr_1_news AS a,
dr_1_news_nbwz AS b 
SET a.keywords = b.keywords,
a.description = b.description,
a.wangzhi = b.wangzhi,
a.wangzhi1 = b.wangzhi1,
a.wangzhi2 = b.wangzhi2,
a.wangzhi3 = b.wangzhi3,
a.wangzhi4 = b.wangzhi4,
a.wangzhi5 = b.wangzhi5,
a.zxwangzhi = b.zxwangzhi,
a.sitetitle = b.sitetitle,
a.pingjia = b.pingjia,
a.sousuozhi = b.sousuozhi,
a.sousuo = b.sousuo,
a.favorites = b.favorites,
a.jibie = b.jibie,
a.beian = b.beian,
a.similarweb = b.similarweb,
a.simi = b.simi,
a.simidate = b.simidate,
a.sspx = b.sspx,
a.title1 = b.title1,
a.catids = b.catids,
-- a.catid = '40',
a.caijilaiyuan = 'nbwz',
b.https = 'OK' 
WHERE
a.title = b.title 
-- AND b.catid = '36';

02.新增新数据

INSERT INTO dr_1_news (
catid,
title,
thumb,
keywords,
description,
uid,
author,
STATUS,
url,
link_id,
tableid,
inputip,
inputtime,
updatetime,
displayorder,
catids,
alexa,
jibie,
pingjia,
wangzhi,
wangzhi1,
wangzhi2,
wangzhi3,
wangzhi4,
paixu,
laiyuan,
favorites,
support,
oppose,
comments,
avgsort,
beian,
similarweb,
simi,
simidate,
fabuye,
title1,
tubiao,
zxwangzhi,
wangzhi5,
zhuangtai,
wailian,
sitetitle,
caijilaiyuan,
caijifulanmu 
) SELECT
'49',
title,
thumb,
keywords,
description,
uid,
author,
STATUS,
url,
link_id,
tableid,
inputip,
inputtime,
updatetime,
displayorder,
catids,
alexa,
jibie,
pingjia,
wangzhi,
wangzhi1,
wangzhi2,
wangzhi3,
wangzhi4,
paixu,
laiyuan,
favorites,
support,
oppose,
comments,
avgsort,
beian,
similarweb,
simi,
simidate,
fabuye,
title1,
tubiao,
zxwangzhi,
wangzhi5,
zhuangtai,
wailian,
sitetitle,
'nbwz2',
'nbwz2' 
FROM
dr_1_news_nbwz 
WHERE
catid = '313' 
AND https is NULL;

03.同步已存在数据副栏目

UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"36"', '"40"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"36"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"37"', '"41"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"37"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"309"', '"42"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"309"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"286"', '"45"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"286"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"189"', '"46"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"189"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"311"', '"47"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"311"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"314"', '"44"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"314"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"348"', '"43"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"348"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"310"', '"104"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"310"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"313"', '"49"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"313"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"73"', '"105"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"73"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"6"', '"146"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"6"%';


UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"280"', '"176"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"280"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"23"', '"177"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"23"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"56"', '"181"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"56"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"40"', '"151"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"40"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"8"', '"155"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"8"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"7"', '"154"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"7"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"41"', '"156"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"41"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"301"', '"276"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"301"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"61"', '"157"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"61"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"63"', '"282"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"63"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"304"', '"283"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"304"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"340"', '"306"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"340"%'; 
UPDATE dr_1_news tb SET tb.catids = REPLACE ( tb.catids, '"306"', '"305"' ),tb.caijifulanmu = 'nbwz2' WHERE tb.catids LIKE '%"306"%';