数据库实验

来源：互联网发布：java 异步请求http 编辑：程序博客网时间：2024/05/16 08:54

create database imr
on                 --创建数据库文件
(NAME= sunquan,--   --数据库文件的额、逻辑名称
filename='D:\SQLDATA\sunquan.mdf;',--物理名称，路径必须存在
size=10,             --数据初始长度为10M
maxsize=50,         --最大长度50M
filegrowth=5%)       --数据文件每次增长5%
LOG on
(
name=imr_log,
filename='D:\SQLDATA\sunquan_log.ldf',
SIZE=1,
maxsize=5,
FILEGROWTH=1;
)
----单击运行按钮即可创建数据库
drop database imr;--删除数据库

use imr;

Create table users(
id INT PRIMARY KEY,
names varchar(20),
password varchar(20),
email varchar(20)
)
Drop table users;

insert into users(id,names,password,email)values(3,'sunquan','123456','5255324@qq.com');
insert into users(id,names,password,email)values(2,'admin','1233456','23423642@sina.com');
select *from users;
select names from users;
select distinct names from users order by names;

select name +'+'+password from

0 0