数据更新 :
INSERT INTO STUDENTS(SNO,SNAME,SEX,BIRTHDAY,ENROLLYEAR,SPECIALITY,DNO)
VALUES(‘200616010’,‘司马相如’,‘男’,’1985-01-28’,‘2006’,‘计算机数学’,‘math‘);
INSERT INTO SC(SNO,CNO)
VALUES(‘200616’,’MA302’);
DELETE FROM STUDENTS
WHERE SNO=’200624010’;
UPDATE TEACHERS
SET TITLE=’副教授’
WHERE TNO=’B050042’;