mysql 创建sql语句 更新aaa

select t1.nid,t1.title,t2.nid,t2.title from ( SELECT ntwo.nid, ntwo.title
FROM node AS ntwo
INNER JOIN content_type_jiaocheng AS jctwo ON ntwo.nid = jctwo.nid
WHERE ntwo.type='jiaocheng' ) as t1 ,(
SELECT n.nid, n.title, jc.field_jiaochengshiping_fid, jc.field_shiping_bofang_intro_value
FROM node AS n
INNER JOIN content_type_jiaocheng AS jc ON jc.nid = n.nid
WHERE jc.field_jiaochengshiping_fid >0
AND n.title LIKE '%aaa%'
) as t2 where replace(replace(concat(t1.title,'aaa'),' ',''),'　','')=replace(replace(t2.title,' ',''),'　','')





update content_type_jiaocheng as t4  inner
join  
(select t1.nid as t31nid,t1.title,t2.nid as t32nid,t2.field_jiaochengshiping_fid as t32jcfid,
t2.field_shiping_bofang_intro_value as t32bofaninfo from ( SELECT ntwo.nid, ntwo.title
FROM node AS ntwo
INNER JOIN content_type_jiaocheng AS jctwo ON ntwo.nid = jctwo.nid
WHERE ntwo.type='jiaocheng' ) as t1 ,(
SELECT n.nid, n.title, jc.field_jiaochengshiping_fid, jc.field_shiping_bofang_intro_value
FROM node AS n
INNER JOIN content_type_jiaocheng AS jc ON jc.nid = n.nid
WHERE jc.field_jiaochengshiping_fid >0
AND n.title LIKE '%aaa%'
) as t2 where replace(replace(concat(t1.title,'aaa'),' ',''),'　','')=replace(replace(t2.title,' ',''),'　','') )as t3
on t4.nid=t3.t31nid  set t4.field_jiaochengshiping_fid=t3.t32jcfid,t4.field_shiping_bofang_intro_value=t3.t32bofaninfo







select * from content_field_shiping_bofang_intro where field_shiping_bofang_intro_value like '%localhost%';

update content_field_shiping_bofang_intro set
 field_shiping_bofang_intro_value=replace(field_shiping_bofang_intro_value,'localhost','211.149.191.199');



select *  from content_field_jiaochengshiping where nid=4149

衣领母型_领座分割之半分割、西装领 3716  aaa 4225  412
衣领母型_领座分割之全分割、小方领 3714  aaa 4227  414
衣领母型_翻驳领、衬衫领           3712  aaa 4215  402
衣领母型_翻驳领、西装领           3710  aaa 4217  404
衣领母型- 坦领1  坦领2            3696  aaa 4229  416
衣领母型_翻驳领、小方领           3708  aaa 4219  406
顶部非平口型辐射环浪平移展开      3734  aaa 4149  336

select *  from content_field_jiaochengshiping where nid=4149

update content_field_jiaochengshiping set nid=412 where nid=3716
update content_field_jiaochengshiping set nid=414 where nid=3714
update content_field_jiaochengshiping set nid=402 where nid=3712
update content_field_jiaochengshiping set nid=404 where nid=3710
update content_field_jiaochengshiping set nid=416 where nid=3696
update content_field_jiaochengshiping set nid=406 where nid=3708
update content_field_jiaochengshiping set nid=336 where nid=3734



select *  from  content_field_shiping_bofang_intro  where nid=4225
select *  from  content_field_shiping_bofang_intro  where nid=4227
select *  from  content_field_shiping_bofang_intro  where nid=4215
select *  from  content_field_shiping_bofang_intro  where nid=4217
select *  from  content_field_shiping_bofang_intro  where nid=4229
select *  from  content_field_shiping_bofang_intro  where nid=4219
select *  from  content_field_shiping_bofang_intro  where nid=4149
 

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=412 where nid=3716;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=414 where nid=3714;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=402 where nid=3712;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=404 where nid=3710;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=416 where nid=3696;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=406 where nid=3708;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value=336 where nid=3734;


select *  from  content_field_shiping_bofang_intro  where nid=4225
select *  from  content_field_shiping_bofang_intro  where nid=4227
select *  from  content_field_shiping_bofang_intro  where nid=4215
select *  from  content_field_shiping_bofang_intro  where nid=4217
select *  from  content_field_shiping_bofang_intro  where nid=4229
select *  from  content_field_shiping_bofang_intro  where nid=4219
select *  from  content_field_shiping_bofang_intro  where nid=4149
 

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Ling_Zuo_Fen_Ge_Zhi_Ban_Fen_Ge_,Xi_Zhuang_Ling_.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3716;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Ling_Zuo_Fen_Ge_Zhi_Quan_Fen_Ge_,Xiao_Fang_Ling_.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3714;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Fan_Bo_Ling_,Chen_Shan_Ling_.flv|streamer=rtmp://211.149.191.199/oflaDemo|image=http://yc.4000512126.com/]' where nid=3712;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Fan_Bo_Ling_,Xi_Zhuang_Ling_.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3710;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Tan_Ling_1,Tan_Ling_2.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3696;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Yi_Ling_Mu_Xing__Fan_Bo_Ling_,Xiao_Fang_Ling_.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3708;

update content_field_shiping_bofang_intro set field_shiping_bofang_intro_value='[jwplayer|config=sample|file=Ding_Bu_Fei_Ping_Kou_Xing_Fu_She_Huan_Lang_Ping_Yi_Zhan_Kai_.flv|streamer=rtmp://118.123.22.204/oflaDemo|image=http://yc.4000512126.com/]' where nid=3734;




update content_field_jiaochengshiping as newobj  inner join
(select field_jiaochengshiping_fid,field_jiaochengshiping_list,field_jiaochengshiping_data
from content_field_jiaochengshiping where nid=4225) as oldobj set
newobj.field_jiaochengshiping_fid=oldobj.field_jiaochengshiping_fid,
newobj.field_jiaochengshiping_list=oldobj.field_jiaochengshiping_list,
newobj.field_jiaochengshiping_data=oldobj.field_jiaochengshiping_data
where newobj.nid=3716

insert into content_field_jiaochengshiping (vid,nid,
field_jiaochengshiping_fid,field_jiaochengshiping_list,field_jiaochengshiping_data)
select 3714,3714,field_jiaochengshiping_fid,field_jiaochengshiping_list,
field_jiaochengshiping_data from content_field_jiaochengshiping where nid=4227;