create database news
use new
create table news
(
id int identity(1,1) primary key,--主键,标识字段
title varchar(20) not null,
content text not null,
infoTime datetime default(getdate()),
)
go
insert into admin(title,content) values('fengyan','fengyan')
go
select * from new