zblog数据迁移到帝国cms用的命令

UPDATE phome_ecms_news set downpath=SUBSTRING_INDEX(downpath,'"buyview"',-1);
UPDATE phome_ecms_news set downpath=REPLACE(downpath,';}','');
select id, downpath,SUBSTRING_INDEX(downpath,'"buyview"',-1) as num from  phome_ecms_news ;
SELECT log_ID, log_Meta,SUBSTRING_INDEX(log_Meta,'"buyview"',-1) as num  FROM zbp_post ;
 UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'}{',',');
 UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'{','(');
 UPDATE phome_ecms_news set keyboard=REPLACE(keyboard,'}',')');
 select tagid,tagname from phome_enewstags where tagid in (22,23,24)
 select tagid,tagname,GROUP_CONCAT(tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in (22,23,24); 
SELECT log_ID, log_Tag, log_Tag=REPLACE(log_Tag,'}{',',') as num  FROM zbp_post ;
select GROUP_CONCAT(tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in  (SELECT keyboard FROM phome_ecms_news where id=1  ) ;
select GROUP_CONCAT(tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in (22,23,24) ;
UPDATE phome_ecms_news set keyboard=(select GROUP_CONCAT( tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in 
(22,23,24)
) where id=1 ;
SELECT LENGTH(keyboard) - LENGTH(REPLACE(keyboard, ',', '')) + 1 AS count
FROM phome_ecms_news where id=3;
select tagid,tagname from phome_enewstags where tagid in (22,23,24)

SELECT mid_keyboard FROM ( SELECT keyboard AS mid_keyboard FROM phome_ecms_news) AS a 
SELECT keyboard FROM (SELECT * FROM phome_ecms_news) P where id=1;
 
 select keyboard from (select * from phome_ecms_news) P;
 Table '78mobancndiguo.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1
UPDATE phome_ecms_news set classid=8  where classid>24;
UPDATE phome_ecms_news_data_1 set classid=8  where classid>24;
UPDATE phome_ecms_news_index set classid=8  where classid>24;

SELECT 
    A.id, A.keyboard typeIds, GROUP_CONCAT(B.`tagname`) AS typeNames
FROM phome_ecms_news A
JOIN phome_enewstags  B ON FIND_IN_SET(B.tagid,A.keyboard)
GROUP BY A.id

select GROUP_CONCAT( tagname SEPARATOR ',') as zuizhong   from phome_enewstags where tagid in 
(1302,1303,7509,7510,7511,7512,3207,7513,4901,4349)
update phome_ecms_article set titleurl=CONCAT('/article/xiaoshuo/',id,'.html');

update phome_ecms_article set titleurl=REPLACE(titleurl,'//','/article/xiaoshuo/');

Table 'moban_aiyiliu_com.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1


[phomenewspic]'article',55,4,128,90,1,20,2[/phomenewspic] 
[phomenewspic]'article',55,4,128,90,1,20,2[/phomenewspic] 
Table 'moban_aiyiliu_com.***_ecms_info_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,email,mycontact,address from ***_ecms_info_data_ where id='7' limit 1

Table 'moban_aiyiliu_com.***_ecms_info_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,email,mycontact,address from ***_ecms_info_data_ where id='7' limit 1


Table 'moban_aiyiliu_com.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1


Table 'moban_aiyiliu_com.***_ecms_' doesn't exist
select * from ***_ecms_ where id='2' limit 1

Table 'moban_aiyiliu_com.***_ecms_download_data_' doesn't exist
select keyid,dokey,newstempid,closepl,infotags,softwriter,homepage,demo,downpath from ***_ecms_download_data_ where id='771' limit 1

update phome_ecms_article set titleurl=REPLACE(titleurl,'xiaoshuo/','');
SELECT * from phome_ecms_news where classid=1;
update phome_ecms_news set titleurl=REPLACE(titleurl,'//','/post/');
update phome_ecms_article set titleurl=REPLACE(titleurl,'xiaoshuo/','');
UPDATE phome_ecms_news set titleurl=CONCAT('/post/',id,'.html');
UPDATE phome_ecms_article set classid=26 where classid=1;