<pre name="code" class="sql">create database test
on
(
name=test_base,
filename='e:\temp\test_data.mdf',
size=3,
maxsize=12,
filegrowth=1
)
log on
(
name=test_log,
filename='e:\temp\test_log.ldf',
size=1,
maxsize=8,
filegrowth=10%
)
create table users(
id int,
username varchar(50),
age int,
location varchar(100),
email varchar(100)
)
select * from users
insert into users(id,username,age,location,email)
values(0,'nicolashe',23,'江西','nicola@y.com')
go
select * from users
update users set email='liuzhongjiezhe001@qq.com' where username='nicolashe'
select * from users;
delete from users where id=0
创建数据库的基础语句
最新推荐文章于 2024-02-29 22:27:18 发布