sql数据跟新

插入数据

1.插入元组

INSERT INTO Student (Sno,Sname,...) VALUES ('20021587','lulu酱');

 

2.插入子查询结果

INSERT INTO Student (Sno,Sname,...)

　　SELECT Tno,Tname,... FROM Teacher GROUP BY Tname;         /*子查询*/

 

修改数据

1.修改某一元组的值

UPDATE Student SET Sage = 22 WHERE Sno = '20023494';

 

2.修改多个元组的值

UPDATE Student SET Sage = Sage + 1;            /*所有的Sage都加1*/

 

3.带子查询的修改语句

UPDATE SC SET Grade = 0 WHERE 'CS' =

　　(SELECT Sdept FROM Student WHERE Student.Sno = SC.Sno);

 

删除数据

1.删除某一个元组的值

DELETE FROM Student WHERE Sno = '2000303897';

 

2.删除多个元组的值

DELETE FROM SC;        /*删除表SC中的所有记录，使之成为空表*/

 

3.带子查询的删除语句

DELETE FROM SC WHERE CS =

　　(SELETE Sdept FROM Student WHERE Student.Sno = SC.Sno);