• 2022-07-24
    把零件号='P2'的零件的重量增加50,颜色改为'黄色',SQL语句为——
    A: UPDATE P SET WEIGHT=WEIGHT+50,COLOR='黄色' WHERE PNO='P2'
    B: INSERT INTO P(PNO,WEIGHT,COLOR) VALUES ('P2',50,'黄色')
    C: DELETE FROM P WHERE WEIGHT=50,COLOR='黄色', PNO='P2'
    D: UPDATE P SET WEIGHT=WEIGHT+50,COLOR=黄色 WHERE PNO=P2