create database db_test charset=utf8;
use db_test;
专业表
create table major(
mid int,
mname varchar(255)
)
学生表
create table student(
sid int,
sname varchar(255),
score float,
joindate DATE
)
#插入数据
insert into major values(10,“影视传媒”);
insert into major values(20,“物联网”);
insert into major values(30,“大数据”);
insert into major values(40,“国际贸易”);
insert into major values(50,“PHP”);
insert into student values(1001,“张大民”,95.5,“2018-03-12”,30);
insert into student values(1002,“刘德华”,93,“2017-09-18”,10);
insert into student values(1003,“刘能”,87,“2018-09-12”,50);
insert into student values(1004,“范冰冰”,89,“2016-11-20”,10);
insert into student values(1005,“周润发”,75,“2017-06-30”,10);
insert