내용

글번호 916
작성자 허진경
작성일 2018-10-11 15:26:56
제목 게시판 샘플 데이터 입력
내용 --카테고리 테이블에 새 카테고리를 추가하세요. --아이디: 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);