数据库应用上机实验指导书

UPDATE s SET sno='s8' WHERE sno='s1'

DELETE FROM s

WHERE SNO='s2'

33

数据库应用上机实验指导书

UPDATE spj SET sno='s8' WHERE sno='s2'

6、验证SPJ表外码PNO的SQL语句及执行结果（插入、删除和修改操作）；

INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S1','p8','J1','100')

UPDATE p SET pno='p8' WHERE pno='p2'

34

数据库应用上机实验指导书

DELETE FROM p

WHERE pno='p3'

UPDATE spj SET pno='p9' WHERE pno='p3'

7、验证SPJ表外码JNO的SQL语句及执行结果（插入、删除和修改操作）；

INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','p3','J9','100')

35

数据库应用上机实验指导书

UPDATE j SET jno='j8' WHERE jno='j2'

DELETE FROM j

WHERE jno='j3'

36