mydata.sql

来自「JavaWeb高级特性书中源代码」· SQL 代码 · 共 32 行

--创建数据库
create database it315
--创建users表和account表
use it315
if object_id('users') is not null drop table users
create table users
(
	id int identity primary key,
	name varchar(10) not null,
	birthday datetime,
	address varchar(40)
)
if object_id('account') is not null drop table account
create table account
(
	id int identity primary key,
	name varchar(10) not null,
	balance int
)
--向表中添加数据
insert into users values('zhangsan','1980-4-1','Beijing')
insert into users values('lisi','1977-9-10','Shanghai')
insert into users values('wangwu','1980-12-3','Shenzhen')
insert into users values('zhaoliu','1979-8-8','Xiamen')
insert into users values('sunqi','1978-4-9','Fuzhou')
insert into users values('qian','1977-7-7','Tianjin')
insert into users values('zhou','1974-9-9','Shanghai')
insert into users values('zheng','1975-6-1','Beijing')
insert into users values('fang','1976-1-1','Beijing')
insert into users values('lufang','1982-6-2','Chengdu')
insert into account values('zhangsan',20000)
insert into account values('lisi',50000)