本文介绍了如何在MySQL中创建user和Student1、Course、SC四张表，并展示了向user表插入一条数据的SQL语句。user表包含id、name、sex和age字段，其中id为主键并自增。Student1表包含了学生的基本信息，Course表存储课程信息，SC表用于建立学生选课的关系，使用外键约束确保数据完整性。
/*create user table*/
create table user(
/*set the id as the primary key ,set this auto_increment type*/
id int primary key auto_increment ,
name char(10) not null,
/*this check sex in male or female ,don't use not null here*/
sex char(6) check(sex in ('male','female')),
age int not null
);
/*this Sql script insert one row into user table*/
insert into user (name,sex,age) values("wanggangdan",'male',18);create table Student1(
Sno char(8) primary key not null,
Sname varchar(10) not null,
Sex char(2) check(Sex in ('男','女')),
Age int not null,
Phonenumber char(12) unique,
Sdept varchar(20) not null
);
create table Course(
Cno char(10) primary key not null,
Cname varchar(20) not null,
Total_perior tinyint,
Week_perior tinyint,
credit tinyint not null,
Pcno char(10)
);
create table SC(
Sno char(8) not null,
Cno char(10) not null,
Grade tinyint,
/*set Sno & Cno as the primary key*/
primary key(Sno,Cno),
/*set the refereneces of Sno & Cno*/
foreign key(Sno) references Student1(Sno),
foreign key(Cno) references Course(Cno)
);
633
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
