mysql查询练习

创建两个表，employee（eno,ename,ebirth,hiredate,depno），每一项代表员工编号、员工名、出生日期、，入职日期、部门号

　　　　　　department(depno,dname,loc,managerno)，每一项代表部门号、部门名、部门经理员工编号

CREATE TABLE employee 
(eno CHAR(9) PRIMARY KEY,
ename VARCHAR(10),
ebirth DATE,
hiredate DATE,
salary FLOAT(1),
depno CHAR(9)
);
CREATE TABLE department

(depno CHAR(9) PRIMARY KEY,

dname VARCHAR(10),

loc VARCHAR(255),

managerno CHAR(9)
);
ALTER TABLE employee

ADD FOREIGN KEY(depno) REFERENCES department(depno);
ALTER TABLE department

ADD FOREIGN KEY(managerno) REFERENCES employee(eno)