数据创建.txt

来自「用jsp实现的留言系统」· 文本 代码 · 共 22 行

create table person
(id int not null,
name varchar(20) not null,
password varchar(20) not null

)
insert into person values('001','万旺', 'wanwang')



create table note 
(id int constraint pk_noteid primary key identity(1,1) not null,
title varchar(20),
author varchar(20),
content varchar(50)

)

insert into note(title,author,content) values('45','343','12')

select * from person
select * from note