文法测试用例.txt

来自「数据库模拟程序 实现控制台命令词法分析」· 文本 代码 · 共 74 行

CREATE TABLE  TNAME
(SSN      VARCHAR(13),
 SNAME   CHAR(12), 
 AGE     INTEGER
);


ALTER TABLE SUNFAN  ADD SALARY  VARCHAR(12);
ALTER TABLE EMPLOYEE DROP JOB VARCHAR(10);
ALTER TABLE EMPLOYEE ADD JOB INTEGER;



DROP TABLE STUDENT1;
DROP INDEX STUDENT2;
DROP VIEW STUDENT3;


INSERT INTO EMPLOYEE
VALUES('HUYUN',4036,'hlj_u','ruanjian','class4');


SELECT E.NAME,ESSN
FROM PROJECT,EMPLOYEE
WHERE((PLOCTION!='HAERBIN') AND
      (((D.DNO>5)AND(D.DNO<8))OR(ESSN=10))AND
      (ESSN=2004)
     );
SELECT *
FROM PROJECT,EMPLOYEE
WHERE((PLOCTION!='HAERBIN') AND
      (((D.DNO>5)AND(D.DNO<8))OR(ESSN=10))AND
      (ESSN=2004)
     );


UPDATE PROJECT
SET PLOCATION='BeiJing',DNUM=5
WHERE((PLOCTION='HAERBIN') AND
      (((DNO>5)AND(DNO<8))OR(ESSN=10))
     );

DELETE
FROM EMPLOYEE
WHERE((PLOCTION='HAERBIN') AND 
      (((DNO>5)AND(DNO<8))OR(ESSN=10))
     );

GRANT select,drop,insert
ON PROJECT
TO USER1,USER2,USER3,USER4;


REVOKE delete,update,drop
ON PROJECT
FROM USER1,USER2,USER3,USER4;


CREATE VIEW SUNFAN
AS SELECT E.NAME,ESSN
FROM PROJECT,EMPLOYEE
WHERE((PLOCTION!='HAERBIN') AND
      ((D.DNO>5)OR(D.DNO<8))
     );
CREATE VIEW SUNFAN
AS SELECT *
FROM PROJECT,EMPLOYEE
WHERE((PLOCTION!='HAERBIN') AND
      (((D.DNO>5)AND(D.DNO<8))OR(ESSN=10))
     );