创建数据库的基础语句

<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