学习数据库的时候写的一些约束代码

--增加主键约束//用一个学号作为每个学生的辨认
alter table (表名) add constraint PK_student_studentno primary key(studentno);

-- 增加非空约束//每个人的名字是非空的
alter table (表名) alter column studentGender varchat(2) not null;

-- 增加唯一约束// 每个人的邮箱是唯一的
alter table (表名) add constraint UQ_student_email unique(email);

--增加一个默认约束//增加一个性别默认约束
alter table (表名) add constraint DF_student_stugender default ('男') for stugender;

--增加一个检查约束//例如性别检查
alter table (表名) add constraint CK_student_stugender check(stugender='男' or stugender='女');

 

//做的笔记

------创建一个用户表

create table users(
userName varchar(20) primary key,
userPassWord varchar(20) not null,
Gender char(2),
Email char(20) unique,
PhoneNumber varchar(11),
AddressName varchar(50)

)

use student;   ----student数据库

 

//插入三条记录
insert into users values('charles','123456','男','123@qq.com','12345678910','广东省东莞市广医');
select * from users;
insert into users values('洗洁精','123456','女','2227008742@qq.com','134334567318','广东省广州市广商');
insert into users
values('百川儿','123456','男','2227008744@qq.com','13038647318','北京市门头沟阿哥');

--update teacher (gender) set ('楠');
insert into teacher (teacherNo,teacherPassword)values('004','123456');
update teacher set gender ='男' where teacherno='005';
insert into teacher (teacherNo,teacherPassword,gender)values('005','123456','女');

select * from teacher;
insert into teacher (teacherNo,teacherPassword)values('006','654321');

--增删改查操作是必须掌握的
update teacher set gender='女' where teacherno='006';
alter table teacher add Age int;
update teacher set Age=35 where teacherno='004';
insert into teacher (teacherno,teacherPassword,gender)values ('007','123456','男');

转载于:https://www.cnblogs.com/DreamList/p/9669925.html