20201015
<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')