1、首先建库、搭建表,搭建练习的环境。
1、建库建表
--create database company
create database company
use company
2、创建表--部门表 create table dept(deptno int(3) primary key,danme varchar (14) ,loc varchar(13));
--往部门表中查数据 insert into dept values(10,'Accounting','New York'); insert into dept values(20,'Research','Dallas'); insert into dept values(30,'Sales','Chicago'); insert into dept values(40,'Operations','Boston'); insert into dept values(50,'Admin','Washing');
--往雇员表中插数据 insert into emp values(7369,'Smith','Clerk',7902,'1980-12-17',800,0,20); insert into emp values(7499,'Allen','Salesman',7698,'1981-2-20',1600,300,30); insert into emp values(7844,'Turner','Salesman',7499,'1981-9-8',1500,0,30); insert into emp values(7698,'Tom','Manager',0,'1981-9-8',6100,600,40); insert into emp values(7876,'Adams','Clerk',7900,'1987-5-23',1100,0,20); insert into emp values(7900,'James','Clerk',7698,'1981-12-3',2400,0,30); insert into emp values(7902,'Ford','Analyst',7698,'1981-12-3',3000,null,20); insert into emp values(7901,'Kik','Clerk',7900,'1981-12-3',1900,0,30);