002_DDL建表

CREATE TABLE tb_emp(
	EMONO INT PRIMARY KEY,
	ENAME VARCHAR(30) NOT NULL,
	JOB VARCHAR(30)NOT NULL,
	MGB INT NOT NULL,
	HIREDATE DATETIME NOT NULL,
	SAL INT NOT NULL,
	COMM INT,
	DEPTNO INT
)#查询数据库所有信息
SELECT * FROM tb_emp;

#插入数据 insert into插入语句， tb_emp数据库名 
INSERT INTO tb_emp (EMONO,ENAME,JOB,MGB,HIREDATE,SAL,COMM,DEPTNO) VALUES(7369, '史密斯','文员',7902,'1980-12-17',800,NULL,20);
INSERT INTO tb_emp (EMONO,ENAME,JOB,MGB,HIREDATE,SAL,COMM,DEPTNO) VALUES(7499, '艾伦','市场销售',7698,'1981-02-20',1600,300,30);
INSERT INTO tb_emp (EMONO,ENAME,JOB,MGB,HIREDATE,SAL,COMM,DEPTNO) VALUES(7521, '沃德','市场销售',7902,'1981-02-22',1250,500,30);
INSERT INTO tb_emp (EMONO,ENAME,JOB,MGB,HIREDATE,SAL,COMM,DEPTNO) VALUES(7566, '琼斯','经理',7839,'1981-02-04',2975,NULL,20);
INSERT INTO tb_emp (EMONO,ENAME,JOB,MGB,HIREDATE,SAL,COMM,DEPTNO) VALUES(7654, '马丁','市场销售',7839,'1980-09-28',1250,1400,30);