mysql -u root -p
mysql -u root -h 192.168.16.140 -p

create database dbstudents;

show databases;

use dbstudents;

create table tbstudents

(

学号 int primary key,

姓名 varchar(30) not null,

性别 varchar(30) not null,

);

insert into tbstudents(学号,姓名,性别)

VALUES

(2055,"张三","男"),

(2056,"张四","男"),

(2057,"张五","女"),

(2058,"张六","男");

create table tbscore

(

学号 int primary key,

语文 int not null,

数学 int not null,

英语 int not null

);

insert into tbscore(学号,语文,数学,英语)

VALUES

(2055,100,99,98),

(2056,99,99,98),

(2057,89,91,93),

(2058,44,69,68);

desc tbstudents;

desc tbscore;

create view 查询表 as select tbstudents.学号,姓名,语文,数学,英语 from tbstudents,tbscore where tbstudents.学号=tbscore.学号;

quit;