SQL常用基础知识的应用示例.docVIP

--创建表 CREATE TABLE DEPT (DID CHAR(3) PRIMARY KEY, DNAME VARCHAR(30) NOT NULL, ADR VARCHAR(50)) CREATE TABLE EMP (EID CHAR(6) PRIMARY KEY, ENAME CHAR(30) NOT NULL, DID CHAR(3), SAL INT, FOREIGN KEY(DID) REFERENCES DEPT(DID)) --删除表 DROP TABLE EMP DROP TABLE DEPT --注意创建和删除表的顺序 --插入数据 INSERT INTO DEPT VALUES(001,销售部,青岛) INSERT INTO DEPT VALUES(002,科技部,北京) INSERT INTO DEPT VALUES(003,生产部,上海) INSERT INTO EMP VALUES(0001,张三,001,2000) INSERT INTO EMP VALUES(0002,李四,001,2500) INSERT INTO EMP VALUES(0011,王五,002,3000) INSERT INTO EMP VALUES(0012,赵六,002,2800) INSERT INTO EM