我觉得这样可行一点
UPDATE oldequipment SET oldequipment.eqID=equipment.eqID,
oldequipment.eqtype=equipment.eqtype,
oldequipment.eqNUM=equipment.eqNUM,
oldequipment.eqMONEY=equipment.eqMONEY,
where
oldequipment='ce2005' and
equipemnt='ce2006'
我也不十分清楚，你试试下面这个嵌套语句：
UPDATE oldequipment SET eqID=(SELECT eqID FROM equipment WHERE quID='ce2006') WHERE eqID='2005'
标签：update,sql,语句
版权声明：文章由 去回答 整理收集，来源于互联网或者用户投稿，如有侵权，请联系我们，我们会立即处理。如转载请保留本文链接：https://www.quhuida.com/answer/86192.html
