我想要把一个P表中所有红色的零件改为浅红色,用以下语句不行。请问错在哪?(其中表中有两个零件是红色的,pno是零件号)
update P
SET color='浅红'
where pno=(select pno,color
from p
where clolor='红')
update P
SET color='浅红'
where pno=(select pno,color
from p
where clolor='红')
color = '浅红'
where color = '红'
SET color='浅红'
where pno IN (select pno
from p
where clolor='红')update P
SET color='浅红' where clolor='红'
p
set
color = '浅红'
where
color = '红'
update
p
set
color = '浅'+color
where
color = '红'
SET color='浅红'
where clolor='红'
SET color='浅红'
where color='红'update P
SET color='浅红'
where clolor='红'