updata.sql

来自「数据库平台 sql的一些基本语句对数据库可以进行修改 删除 插入 等 操作」· SQL 代码 · 共 17 行

UPDATE SC
SET GRADE=GRADE*0.1+GRADE
WHERE SC.C#='C2';

DELETE FROM SC
WHERE SC.C# IN 
			(	SELECT C#
			    FROM C
				WHERE CNAME='PHYSICS' );

DELETE FROM S
WHERE S.S#='S8';
DELETE FROM SC
WHERE SC.S#='S8';