Tarena - 表的创建

表的创建

Oracle版本：
CREATE TABLE emp(
    empno NUMBER(4),
    ename VARCHAR2(10),
    job VARCHAR2(9),
    mgr NUMBER(4),
    hiredate DATE,
    sal NUMBER(7,2),
    comm NUMBER(7,2)
);
MySQL版本：
CREATE TABLE emp(empno int,ename varchar(10),job varchar(9),mgr int,hiredate date,sal double,comm double,deptno int);
CREATE TABLE dept(deptno int,dname varchar(14),loc varchar(13));

插入数据
INSERT INTO emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) VALUES(7369,'SMITH','CLERK',7902,19801217,800,NULL,20);
INSERT INTO emp(empno,ename,job,mgr,hiredate,sal,comm,deptno) VALUES(7499,'ALLEN