Mysql 创表作业
建立 grade表格和数据
create table grade(
sid int(4) primary key auto_increment,
class int(8),
name varchar(20),
chinese int(20),
english int(20),
math int(20),
age int(20));
insert into grade values(1,1833,'zhansan',86,90,40,21),
(2,1832,'lisi',56,86,66,22),(3,1833,'zhaoliu',93,57,98,23),(4,1832,'wangwu',84,90,88,25),
(5,1833,'lijiu',93,27,22,26),(6,1832,'niuqi',84,98,77,26),
(7,1832,'liuqi',null,57,77,27),(8,1833,'wangbo',45,58,88,28),
(9,1832,'wangsan',78,57,88,29),(10,1833,'wangan',87,60,65,30),
(11,1832,'wangping',80,76,88,31),(12,1833,'wanghui',null,79,88,32)
建立 emp 表格和数据
create table emp(
-> sid int(10) primary key,
-> name varchar(20),age int(20),warktime_start date,incoming int(20),dept2 int(20));
insert into emp values（1789，'张三',35,'1980/1/1',4000,101）
(1674,'李四',32,'1983-04-01',3500,101)，(1776,'王五',24,'1990-07-01',2000,101)，
(1568,'赵六',57,'1970-10-11',7500,102)，(1564,'荣七',64,'1963-10-11',8500,102），
(1879,'牛八',55,'1971-10-20',7300,103)
建立 dept 表格和数据
create table dept(dept1 int(10) primary key,dept_name varchar(20));
insert into dept values(101,'财务'),(102,'销售')，
(103,'IT技术'),(104,'行政');
页:
[1]