数据库|mysql教程
语句,添加,约束
数据库-mysql教程
源码机,ctf攻防ubuntu防守,厨房出现的爬虫,ideacms PHP版,seo文本教程lzw
—–检查数据库是否存在——- use master go if exists(select*from sysdatabases where) drop database studentdb ——建数据库——– create database studentdb on primary( name=’student’, filename=’d:\data\student.mdf’, size=15, maxsize=25
系统源码交易,ubuntu解压找不到,tomcat一直登陆不上,利用api写爬虫,php程序员外包多少钱,南京seo技巧lzw
php刷信誉平台源码,ubuntu界面卡慢,tomcat定时关闭和启动,人民制作爬虫,手机配置php环境,3年seo工作经验在苏州薪资lzw
—–检查数据库是否存在——-
use master
go
if exists(select*from sysdatabases where)
drop database studentdb
——建数据库——–
create database studentdb
on primary(
name=’student’,
filename=’d:\data\student.mdf’,
size=15,
maxsize=25,
filegrowth=10%
)
log on (
name=’student_log’,
filename=’d:\data\student_log.ldf’,
size=20,
filegrowth=1
)
——修改数据库——–
alter database studentdb
modify file(
name=’student_log’,
maxsize=500
)
alter database studentdb
modify file(
name=’student’,
filegrowth=3
)
——创建表———
use studentdb
go
if exists(select * from sysobjects where)
drop table t_class
create table t_class(
C_Id char(6) primary key not null,
C_Number varchar(30) unique not null,
C_Depart varchar(30) null
)
use studentdb
go
if exists(select * from sysobjects where)
drop table t_student
create table t_student(
S_Id char(6) primary key not null,
C_Id char(6) not null,
S_Name varchar(30) null,
S_Gender char(2) check(S_Gender in(‘男’,’女’)) null,
S_Birthday datetime not null,
S_Nation char(10) null,
s_idcard varchar(18) check(len(s_idcard) in(15,18)) not null,
s_email varchar(50) check(s_email like ‘%@%’) not null
)
——-向表中添加信息———
insert into t_class values(’01’,’软件技术班’,’计算机技术系’)
insert into t_class values(’02’,’网络技术班’,’计算机技术系’)
insert into t_class values(’03’,’会计班’,’经贸系’)
insert into t_student (S_Id,C_Id,S_Name,S_Gender,S_Birthday,S_Nation) values (‘001′,’01’,’李林’,’男’,’1998-8-9′,’汉’)
insert into t_student (S_Id,C_Id,S_Name,S_Gender,S_Birthday,S_Nation) values (‘002′,’01’,’黄莺’,’女’,’1980-11-2′,’满’)
insert into t_student (S_Id,C_Id,S_Name,S_Gender,S_Birthday,S_Nation) values (‘003′,’03’,’张华’,’男’,’1991-3-19′,’汉’)
——修改信息---------
update t_student set S_Name=’李大林’ where S_Id=001
——–显示男同学的信息------
select * from t_student where S_Gender=’男’
———显示特定信息-----
select * from t_student where year(S_Birthday)=1998
——–删除特定信息-------
delete from t_student where C_Id=’01’
select * from t_student
,香港虚拟主机,香港空间,香港虚拟主机
如果觉得《SQL语句添加约束》对你有帮助,请点赞、收藏,并留下你的观点哦!