내용 |
--카테고리 테이블에 새 카테고리를 추가하세요.
--아이디: 10, 분류1 : 한국소프트웨어산업협회, 분류2: 과제게시판
--카테고리이름 : 2018 빅데이터
--설명 : 2018 빅데이터
INSERT INTO BOARD_CATEGORY
(category_id, category_class1, category_class2, category_name, category_description)
VALUES (10, '한국소프트웨어산업협회', '과제게시판', '2018 빅데이터', '2018 빅데이터');
SELECT * FROM board_category;
--게시글을 입력하세요.
--게시글 아이디 : 1, 카테고리 아이디 : 10, 작성자 : 홍길동
--이메일 : hong@hong.com, 제목 : 반갑습니다. 내용 : 내용 없음, 작성일 : 2018-10-11
--비밀번호 : 1234, 메인글아이디 : 1, 댓글순서 : 0, 댓글 단계 : 0, 조회수 : 0
-- 2, 1, 이순신, lee@lee.com, 나도, 내용없음, 1234, 2018-10-11, 2, 0, 0
-- 3, 1, 홍길동, hong@hong.com, 오랜만이야, 그렇지, 1234, 28-10-12, 2, 1, 1
-- 4, 1, 무명씨, noname@name.com, 할루, 재미없음, 1234, 2018-10-11, 4, 0, 0
-- 5, 1, 홍길서, seo@hong.com, 나도, 나도나도, 1234, 2018-10-11, 2, 2, 1
-- 6, 1, 조심씨, josin@josim.com, 조심해, 안전하게, 1234, 2018-10-11, 2, 1, 2
-- 7, 1, 안전씨, an@anjeon.com, 자나깨나, 불조심, 1234, 2018-10-11, 4, 1, 1
-- 8, 1, 소심씨, so@somcom, 잘삐져, 조심씨, 1234, 2018-10-11, 2, 1, 3
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(1, 10, '홍길동', 'hong@hong.com', '반갑습니다', '내용 없음', to_date('2018-10-11', 'YYYY-MM-DD'),
'1234', 1, 0, 0, 0);
SELECT * FROM BOARD;
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(2, 10, '이순신', 'lee@lee.com', '나도', '내용없음', to_date('2018-10-11', 'YYYY-MM-DD'),
'1234', 2, 0, 0, 0);
SELECT * FROM BOARD;
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(3, 10, '홍길동', 'hong@hong.com', '오랜만이야', '그렇지', to_date('2018-10-12', 'YYYY-MM-DD'), '1234', 2, 1, 1, 0);
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(4, 10, '무명씨', 'noname@name.com', '할루', '재미없음', to_date('2018-10-13', 'YYYY-MM-DD'), '1234', 4, 0, 0, 0);
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(5, 10, '홍길서', 'seo@hong.com', '나도', '나도나도', to_date('2018-10-14', 'YYYY-MM-DD'), '1234', 2, 2, 1, 0);
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(6, 10, '조심씨', 'josin@josim.com', '조심해', '안전하게', to_date('2018-10-15', 'YYYY-MM-DD'), '1234', 2, 1, 2, 0);
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(7, 10, '안전씨', 'an@anjeon.com', '자나깨나', '불조심', to_date('2018-10-16', 'YYYY-MM-DD'), '1234', 4, 1, 1, 0);
INSERT INTO board
(board_id, category_id, writer, email, title, content, write_date, password,
master_id, reply_number, reply_step, read_count)
VALUES
(8, 10, '소심씨', 'so@somcom', '잘삐져', '조심씨', to_date('2018-10-17', 'YYYY-MM-DD'), '1234', 2, 1, 3, 0);
|