我今天学习了一下数据库简单的SQL语言。
1.建立数据库:
cerate database Users
2.建立数据库的位置:
on primary(
Filename =’d:\data\data/mdf’,
Size=50mb,
Maxsize=100mb,
Filegrowth=2mb
)
Log on (
Name=’Users_ldf’,
Filenname=’d:\data\data.ldf’,
Size=5mb,
Maxsize=25mb,
Filegrowth=10%
)
3.创建表:
create table student(
Id int identity(101,1)primary key,
Name varchar(60) not null,
Password varchar(10)
)
4.查询:
Select * from student
6.插入一条数据:
Insert into student (name,password) values(‘得瑟夫’,’789’)
声明:此篇文档时来自于【狗刨学习网】社区-unity极致学院,是网友自行发布的Unity3D学习文章,如果有什么内容侵犯了你的相关权益,请与官方沟通,我们会即时处理。
7.插入多条语句
Insert into student (name,password)
Select ‘温柔’ , ’888’union
Select ‘威尔’, ‘432’union
Select ‘卫生点’,’324’
8.更新一条语句
Update student set name =’娃儿’ where id=103
9.删除一条语句
Delete from student where id=101
10.删除一行
Delete table student where id=102
11.删除数据库
Drop database third