MySQL:数据库练习题-2

廖王八

已于 2022-08-20 12:10:10 修改

阅读量5.6k

点赞数 9

分类专栏： MySQL 文章标签： mysql sql

于 2022-08-12 11:40:49 首次发布

本文链接：https://blog.csdn.net/ljl17880248619/article/details/126264464

版权

表一：xs（学生）

USE xscj
SELECT * FROM xs
INSERT into xs VALUES
('081101','王林','计算机',1,'1990-02-10',50,'null','null'),
('081102','程明','计算机',1,'1991-02-01',50,'null','null'),
('081103','王燕','计算机',0,'1989-10-06',50,'null','null'),
('081104','韦严平','计算机',1,'1990-08-26',50,'null','null'),
('081106','李方方','计算机',1,'1990-11-20',50,'null','null'),
('081107','李明','计算机',1,'1990-02-01',54,'null','提前修完《数据结构》'),
('081108','林一帆','计算机',1,'1989-08-05',52,'null','已提前修完一门课'),
('081109','张强民','计算机',1,'1989-08-11',50,'null','null'),
('081110','张蔚','计算机',0,'1991-07-22&#