대문

한국학대학원

2020년

인문정보학 수업

인문정보데이터베이스2020: 2020-2 AKS 인문정보학

• 2020.10.15 <join실습>

select * from jdcWebLink$
join jdcWebNode$ on jdcWebLink$.target=jdcWebNode$.id
where source='자경전'

use s_phj

select * from sys.tables

/* jdcDomainNode$ jdcPhotoNode$ jdcWebNode$

• /

select * from jdcPhotolink$ select * from jdcDomainNode$

where label='자경전' select * from jdcWebNode$

select * from jdcPhotoLink$ join jdcPhotoNode$.target on jdcPhotoLink$.id

select * from jdcWebLink$ join jdcWebNode$ on jdcWebLink$.target=jdcWebNode$.id where source='자경전'

select * from jdcDomainNode$ select class, groupName, partName, count(*) from jdcDomainNode$ group by class, groupName, partName order by class, groupName, partName

select * from jdcPhotoNode$

create table jdcPhotoNode ( id nvarchar(40) not NULL, class nvarchar(40) NULL, groupName nvarchar(40) NULL, label nvarchar(80) NULL, infoUrl nvarchar(256) NULL, iconUrl nvarchar(256) NULL, note nvarchar(256) NULL, primary key(id) )

select * from jdcPhotoNode

insert into jdcPhotoNode(id, class, groupName, label, infoUrl, iconUrl) select id, class, groupName, label, infoUrl, iconUrl from jdcPhotoNode$ select * from jdcPhotoNode

insert into jdcPhotoNode (id, label) values ('새로_찾은_사진_001', '데이터베이스_수업1')

연구개발프로젝트수행방법론: 2020-2 AKS 인문정보학

• 부여지역 백제왕도 핵심유적