编辑代码

CREATE DATABASE db_test1;
use db_test1;
create table classes(
    class_id int primary key auto_increment,
    class_name varchar(40) not null unique,
    class_remark varchar(200)
);
insert into classes(class_name,class_remark) values('java001','kuku01');
insert into classes(class_name,class_remark) values('java002','kuku02');
insert into classes(class_name,class_remark) values('java003','kuku03');
insert into classes(class_name,class_remark) values('java004','kuku04');
insert into classes(class_name,class_remark) values('java005','kuku05');
create table students(
    stu_num char(8) primary key,
    stu_name varchar(20) not null,
    stu_gender char(2) not null,
    stu_age int not null,
    cid int unique,
    constraint FK_STUDENTS_CLASSES foreign key(cid) references classes(class_id)
);
insert into students(stu_num,stu_name,stu_gender,stu_age,cid) values('20250001','panjun','男',18,1);
insert into students(stu_num,stu_name,stu_gender,stu_age,cid) values('20250002','panjun01','男',18,2);
insert into students(stu_num,stu_name,stu_gender,stu_age,cid) values('20250003','panjun02','男',18,3);
insert into students(stu_num,stu_name,stu_gender,stu_age,cid) values('20250004','panjun03','男',20,4);
insert into students(stu_num,stu_name,stu_gender,stu_age,cid) values('20250005','panjun04','男',18,5);

select * from students;