"20201015"의 두 판 사이의 차이
(새 문서: <join실습> select * from jdcWebLink$ join jdcWebNode$ on jdcWebLink$.target=jdcWebNode$.id where source='자경전' use s_phj select * from sys.tables /* jdcDomainNode$ jdcPh...) |
|||
5번째 줄: | 5번째 줄: | ||
− | use s_phj | + | use s_phj |
− | select * from sys.tables | + | *모든 테이블을 보여줘라 |
+ | select * from sys.tables | ||
/* | /* |
2020년 10월 26일 (월) 22:50 판
<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')