Korea Insam (Home)

국내시장

해외시장

업체동향

생산유통

연구개발

정책

기타

뉴스데스크

오늘의 날짜가 입력2222

빈 칸일 때 그렇다.

Create Table is_newsdesk
(
news_id int primary key,
flg_headline char(1),
news_category int,
news_source int,
news_date varchar(12),
news_code1 varchar(2),
news_code2 varchar(2),
news_code3 varchar(2),
news_cmp_code varchar(5),
news_prd_code varchar(2),
news_title varchar(120),
news_subtitle varchar(120),
news_content1 varchar(2000),
news_content2 varchar(2000),
news_content3 varchar(2000)
);

create table is_category
(
cat_id int primary key,
cat_name varchar(20)
);

create table is_source
(
src_id int primary key,
src_name varchar(20)
);

"insert into is_category values(1, '국내시장');"
"insert into is_category values(2, '해외시장');"
"insert into is_category values(3, '업체동향');"
"insert into is_category values(4, '생산유통');"
"insert into is_category values(5, '연구개발');"
"insert into is_category values(6, '정책');"
"insert into is_category values(9, '기타');"

"insert into is_source values(11, '조선일보');"
"insert into is_source values(12, '중앙일보');"
"insert into is_source values(13, '동아일보');"
"insert into is_source values(14, '한겨레신문');"
"insert into is_source values(15, '한국일보');"
"insert into is_source values(16, '국민일보');"
"insert into is_source values(17, '대한매일');"
"insert into is_source values(20, '매일경제');"
"insert into is_source values(21, '한국경제');"
"insert into is_source values(22, '서울경제');"
"insert into is_source values(25, '일간스포츠');"
"insert into is_source values(26, '스포츠서울');"
"insert into is_source values(30, '서울/연합뉴스');"
"insert into is_source values(31, '충청일보');"
"insert into is_source values(41, 'KOTRA');"
"insert into is_source values(51, '농촌진흥일보');"
Create Table is_newsdesk
(
news_id int primary key,
flg_headline char(1),
news_category intt,
news_source int,
news_date varchar(12),
news_code1 varchar(2),
news_code2 varchar(2),
news_code3 varchar(2),
news_cmp_code varchar(5),
news_prd_code varchar(2),
news_title varchar(120),
news_subtitle varchar(120),
news_content1 varchar(2000),
news_content2 varchar(2000),
news_content3 varchar(2000)
);

create table is_category
(
cat_id int primary key,
cat_name varchar(20)
);

create table is_source
(
src_id int primary key,
src_name varchar(20)
);

"insert into is_category values(1, '국내시장');"
"insert into is_category values(2, '해외시장');"
"insert into is_category values(3, '업체동향');"
"insert into is_category values(4, '생산유통');"
"insert into is_category values(5, '연구개발');"
"insert into is_category values(6, '정책');"
"insert into is_category values(9, '기타');"

"insert into is_source values(11, '조선일보');"
"insert into is_source values(12, '중앙일보');"
"insert into is_source values(13, '동아일보');"
"insert into is_source values(14, '한겨레신문');"
"insert into is_source values(15, '한국일보');"
"insert into is_source values(16, '국민일보');"
"insert into is_source values(17, '대한매일');"
"insert into is_source values(20, '매일경제');"
"insert into is_source values(21, '한국경제');"
"insert into is_source values(22, '서울경제');"
"insert into is_source values(25, '일간스포츠');"
"insert into is_source values(26, '스포츠서울');"
"insert into is_source values(30, '서울/연합뉴스');"
"insert into is_source values(31, '충청일보');"
"insert into is_source values(41, 'KOTRA');"
"insert into is_source values(51, '농촌진흥일보');"
Create Table is_newsdesk
(
news_id int primary key,
flg_headline char(1),
news_category int,
news_source int,
news_date varchar(12),
news_code1 varchar(2),
news_code2 varchar(2), news_code3 varchar(2),
news_cmp_code varchar(5),
news_prd_code varchar(2),
news_title varchar(120),
news_subtitle varchar(120),
news_content1 varchar(2000),
news_content2 varchar(2000),
news_content3 varchar(2000)
);

create table is_category
(
cat_id int primary key,
cat_name varchar(20)
);

create table is_source
(
src_id int primary key,
src_name varchar(20)
);

"insert into is_category values(1, '국내시장');"
"insert into is_category values(2, '해외시장');"
"insert into is_category values(3, '업체동향');"
"insert into is_category values(4, '생산유통');"
"insert into is_category values(5, '연구개발');"
"insert into is_category values(6, '정책');"
"insert into is_category values(9, '기타');"

"insert into is_source values(11, '조선일보');"
"insert into is_source values(12, '중앙일보');"
"insert into is_source values(13, '동아일보');"
"insert into is_source values(14, '한겨레신문');"
"insert into is_source values(15, '한국일보');"
"insert into is_source values(16, '국민일보');"
"insert into is_source values(17, '대한매일');"
"insert into is_source values(20, '매일경제');"
"insert into is_source values(21, '한국경제');"
"insert into is_source values(22, '서울경제');"
"insert into is_source values(25, '일간스포츠');"
"insert into is_source values(26, '스포츠서울');"
"insert into is_source values(30, '서울/연합뉴스');"
"insert into is_source values(31, '충청일보');"
"insert into is_source values(41, 'KOTRA');"
"insert into is_source values(51, '농촌진흥일보');"
2000-12-28

[이전 기사] [다음 기사] [List]