您的位置首页百科知识

update sql语句如何写

Simone 发布于 2025-05-12 13:50:39 531 阅读

的有关信息介绍如下：

update sql语句如何写

我觉得这样可行一点

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,语句