MySQL创建表和添加数据

最新推荐文章于 2024-08-08 18:50:15 发布

BREAK_TP

最新推荐文章于 2024-08-08 18:50:15 发布

阅读量1.5w

点赞数 24

分类专栏： SQL 文章标签： mysql

本文链接：https://blog.csdn.net/weixin_44466545/article/details/109059451

版权

SQL 专栏收录该内容

3 篇文章 1 订阅

订阅专栏

一.创建表

在这里插入图片描述

创建表
mysql> create table Student(Sno char(9) primary key,Sname char(20) not null,Ssex char(2),Sage smallint,Sdept char(20));
mysql> create table Course(Cno char(4) primary key,Cname char(40) not null,Cpno char(4) references Course(Cno),Ccredit smallint);
mysql> create table SC(Sno char(9),Cno char(4),Grade smallint,primary key(Sno,Cno),foreign key(Sno) references Student(Sno),foreign key (Cno) references Course(Cno));

添加student表数据
mysql>insert into Student(Sno,Sname,Ssex,Sage,Sdept)values('201215121','李勇','男','20','CS');
mysql>insert into Student(Sno,Sname,Ssex,Sage,Sdept)values('201215122','刘晨','女','19','CS');
mysql>insert into Student(Sno,Sname,Ssex,Sage,Sdept)values('201215123','王敏','女','18','MA');
mysql>insert into Student(Sno,Sname,Ssex,Sage,Sdept)values('201215125','张立','男','19','IS');
添加Course表数据
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('1','数据库','5','4');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('2','数学','null','2');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('3','信息系统','1','4');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('4','操作系统','6','3');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('5','数据结构','7','4');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('6','数据处理','null','2');
mysql> insert into Course(Cno,Cname,Cpno,Ccredit)values('7','PASCLA语言','6','4');
添加SC表数据
mysql> insert into SC(Sno,Cno,Grade)values('201215121','1','92');
mysql> insert into SC(Sno,Cno,Grade)values('201215121','2','85');
mysql> insert into SC(Sno,Cno,Grade)values('201215121','3','88');
mysql>  insert into SC(Sno,Cno,Grade)values('201215122','2','90');
mysql>  insert into SC(Sno,Cno,Grade)values('201215122','3','80');