数据库实验三
3-2
DELTE FROM test3_03
WHERE
(sex != '男' and sex != '女' and sex IS NOT NULL)
3-3
CREATE TABLE test3_03 AS
SELECT * FROM pub.student_31;
DELETE FROM ?test3_03
WHERE
(sex != '男' and sex != '女' and sex IS NOT NULL;
3-4
CREATE TABLE test3_04 AS
SELECT * FROM pub.student_31;
DELETE FROM test3_04 WHERE
(dname IS NULL) OR (length(dname) < 3) OR
(length(dname) > length(trim(dname)))
3-5
CREATE TABLE test3_05
AS
SELECT * FROM pub.student_31
DELETE FROM TEST3_05
WHERE
(length(class ) != 4)
3-6
DELETE FROM test3_06
WHERE
name like '% %' or length(name) < 2
3-7
CREATE TABLE test3_07
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_07
WHERE
sid not in (SELECT sid FROM pub.student)
3-8
CREATE TABLE test3_07
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_08 t3
WHERE
cid not in
(
SELECT cid FROM pub.teacher_course p WHERE
p.tid = t3.tid
)
3-9
CREATE TABLE test3_09
AS
SELECT * FROM pub.student_course_32
DELETE FROM test3_09
WHERE
score < 0 or score > 100
3-10
CREATE TABLE test3_10ASSELECT * FROM pub.student_course_32DELETE FROM test3_10WHEREsid not in (SELECT sid FROM pub.student)DELETE FROM test3_10 t3WHEREcid not in(SELECT cid FROM pub.teacher_course p WHEREp.tid = t3.tid)