게시판 만들기 (DB)

Create Table Article(
article_id number constraint article_id_pk primary key,
group_id number not null,
sequence_No Char(16),
Posting_Date Date,
Read_Count Number,
Writer_Name Varchar2(20),
Passwd Varchar2(10),
Title Varchar2(100),
Content Varchar2(2000)
);

 

Create Sequence Article_Group_Seq;
nocache;
Create Sequence Article_Seq;
nocache;

 

Insert Into Article(article_id, group_id, posting_date, read_count, writer_name,passwd,title,content)
Values (Article_Seq.Nextval, Article_Group_Seq.Nextval, Sysdate,0,
'관리자','1234','문의사항을 남겨주세요','가능한 빠른 시간안에 답변드리겠습니다.');

 

commit;

 

Desc  Article;
select * from article;

 

Update Article
Set Sequence_No = '999999'
Where Article_Id = 1;

Commit;

 

select article_id, group_id, sequence_no
from article;