数据库应用上机实验指导书
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
