求一条SQL执行语句,试了半天,还是不行! 在同一个数据中,不同的两个表,源表 和 目标表,两个表有若干个字段是相同的,也有很多不同字段。要实现的操作:将源表中的数据复制到目标表,但只复制相同的字段,其他不同字段丢弃不要,要求复制所有2000多条数据,一条不落。只是扔掉某些字段而已。上图:问题简单,不要笑,小弟是新手!SQLmysql 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我这么写,提示错误!1054-unknown column'destoon_quote.itemid'in'field list'update destoon_article_43 set itemid =destoon_quote.itemid,catid=destoon_quote.catid,areaid=destoon_quote.areaid,level=destoon_quote.level,title=destoon_quote.title,style=destoon_quote.style,introduce=destoon_quote.introduce,tag=destoon_quote.tag,keyword=destoon_quote.keyword,pptword=destoon_quote.pptword,hits=destoon_quote.hits,thumb=destoon_quote.thumb,addtime=destoon_quote.addtime,edittime=destoon_quote.edittime,template=destoon_quote.template,destoon_article_43.`status`=destoon_quote.`status`,linkurl=destoon_quote.linkurl,filepath=dstoon_quote.filepath 我这么写,提示错误!1054-unknown column'destoon_quote.itemid'in'field list'UPDATE destoon_article_43 SET itemid = destoon_quote.itemid,catid = destoon_quote.catid,areaid = destoon_quote.areaid,LEVEL = destoon_quote.level,title = destoon_quote.title,style = destoon_quote.style,introduce = destoon_quote.introduce,tag = destoon_quote.tag,keyword = destoon_quote.keyword,pptword = destoon_quote.pptword,hits = destoon_quote.hits,thumb = destoon_quote.thumb,addtime = destoon_quote.addtime,edittime = destoon_quote.edittime,template = destoon_quote.template,destoon_article_43.`status` = destoon_quote.`status` ,linkurl = destoon_quote.linkurl,filepath = dstoon_quote.filepath 看看哪里有错?为什么执行条数为 0update destoon_article_43 p, destoon_quote ppSET p.itemid = pp.itemid,p.catid = pp.catid,p.areaid = pp.areaid,p.level = pp.level,p.title = pp.title,p.style = pp.style,p.introduce = pp.introduce,p.tag = pp.tag,p.keyword = pp.keyword,p.pptword = pp.pptword,p.hits = pp.hits,p.thumb = pp.thumb,p.addtime = pp.addtime,p.edittime = pp.edittime,p.template = pp.template,p.status = pp.status ,p.linkurl = pp.linkurl,p.filepath = pp.filepath insert into A(A1,A2,A3) select B1,B2,B3 from B; 如果是复制则应该使用insert into destoon_article_43(itemid ,catid ,areaid ,level ,title ,style ,introduce ,tag ,keyword ,pptword ,hits ,thumb ,addtime ,edittime ,template ,status ,linkurl ,filepath)select itemid,catid,areaid,level,title,style,introduce,tag,keyword,pptword,hits,thumb,addtime,edittime,template,status ,linkurl,filepath from destoon_quote 如何批量修改数据库中所有表的指定查找内容? 登陆mysql 必须到root 用户下 才能执行?? 64位linux上运行mysql4.0.20的问题 mysql直接数据库文件覆盖后innodb的表无法访问了,怎么按 请教,千万条记录怎么快速查询出来. mysql改密码后,连接不上? #紧急#求助mysql 登陆不了 一个很弱智的问题,message表应该怎样设计 mysql分表怎么处理比较合适? 新人求助 Mysql中触发器问题 mysql查询速度快慢
catid = destoon_quote.catid,
areaid = destoon_quote.areaid,
LEVEL = destoon_quote.level,
title = destoon_quote.title,
style = destoon_quote.style,
introduce = destoon_quote.introduce,
tag = destoon_quote.tag,
keyword = destoon_quote.keyword,
pptword = destoon_quote.pptword,
hits = destoon_quote.hits,
thumb = destoon_quote.thumb,
addtime = destoon_quote.addtime,
edittime = destoon_quote.edittime,
template = destoon_quote.template,
destoon_article_43.`status` = destoon_quote.`status` ,
linkurl = destoon_quote.linkurl,
filepath = dstoon_quote.filepath
SET p.itemid = pp.itemid,
p.catid = pp.catid,
p.areaid = pp.areaid,
p.level = pp.level,
p.title = pp.title,
p.style = pp.style,
p.introduce = pp.introduce,
p.tag = pp.tag,
p.keyword = pp.keyword,
p.pptword = pp.pptword,
p.hits = pp.hits,
p.thumb = pp.thumb,
p.addtime = pp.addtime,
p.edittime = pp.edittime,
p.template = pp.template,
p.status = pp.status ,
p.linkurl = pp.linkurl,
p.filepath = pp.filepath
select itemid,catid,areaid,level,title,style,introduce,tag,keyword,pptword,hits,thumb,addtime,edittime,template,status ,linkurl,filepath from destoon_quote