MySQL软件操作及建库建表建数据

最新推荐文章于 2024-07-09 22:51:17 发布

李孟安

最新推荐文章于 2024-07-09 22:51:17 发布

阅读量153

点赞数 1

分类专栏：数据库文章标签： sql

本文链接：https://blog.csdn.net/m0_73721470/article/details/138546244

版权

数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

第1关：创建数据库

#请在此处添加实现代码
########## Begin ##########
create database mydata;
########## End ##########
#以下代码禁止删除
show databases;

第2关：创建供应商表S，并插入数据

USE mydata;
#请在此处添加实现代码
########## Begin ##########
CREATE TABLE S(
    SNO VARCHAR(10),
    SNAME VARCHAR(10),
    STATUS INT,
    CITY VARCHAR(10)
);
INSERT INTO S(sno, sname, status, city) VALUES 
('S1','精益',20,'天津'),
('S2','盛锡',10,'北京'),
('S3','东方红',30,'北京'),
('S4','丰泰盛',20,'天津'),
('S5','为民',30,'上海');
########## End ##########
#以下代码禁止删除
SELECT * FROM S;

第3关：创建零件表P，并插入数据

USE mydata;
#请在此处添加实现代码
########## Begin ##########
CREATE TABLE P(
    PNO VARCHAR(10),
    PNAME VARCHAR(10),
    COLOR VARCHAR(10),
    WEIGHT INT
);
INSERT INTO P(PNO, PNAME, COLOR, WEIGHT) VALUES
('P1','螺母','红',12),
('P2','螺栓','绿',17),
('P3','螺丝刀','蓝',14),
('P4','螺丝刀','红',14),
('P5','凸轮','蓝',40),
('P6','齿轮','红',30);
########## End ##########
#以下代码禁止删除
SELECT * FROM P;

第4关：创建工程项目表J，并插入数据

USE mydata;
#请在此处添加实现代码
########## Begin ##########
CREATE TABLE J(
    JNO VARCHAR(10),
    JNAME VARCHAR(10),
    CITY VARCHAR(10)
);
INSERT INTO J(JNO, JNAME, CITY) VALUES
('J1','三建','北京'),
('J2','一汽','长春'),
('J3','弹簧厂','天津'),
('J4','造船厂','天津'),
('J5','机车厂','唐山'),
('J6','无线电厂','常州'),
('J7','半导体厂','南京');

########## End ##########
#以下代码禁止删除
SELECT * FROM J;

第5关：创建供应情况表SPJ，并插入数据

USE mydata;
#请在此处添加实现代码
########## Begin ##########
CREATE TABLE SPJ(
    SNO VARCHAR(10),
    PNO VARCHAR(10),
    JNO VARCHAR(10),
    QTY INT
);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S1','P1','J1',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S1','P1','J3',100);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S1','P1','J4',700);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S1','P2','J2',100);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P3','J1',400);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P3','J2',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P3','J4',500);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P3','J5',400);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P5','J1',400);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S2','P5','J2',100);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S3','P1','J1',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S3','P3','J1',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S4','P5','J1',100);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S4','P6','J3',300);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S4','P6','J4',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S5','P2','J4',100);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S5','P3','J1',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S5','P6','J2',200);
INSERT INTO SPJ(SNO,PNO,JNO,QTY) VALUES('S5','P6','J4',500);

########## End ##########
#以下代码禁止删除
SELECT * FROM SPJ;