"20201015"의 두 판 사이의 차이
9번째 줄: | 9번째 줄: | ||
*모든 테이블을 보여줘라 | *모든 테이블을 보여줘라 | ||
select * from sys.tables | select * from sys.tables | ||
− | + | <pre> | |
/* | /* | ||
jdcDomainNode$ | jdcDomainNode$ | ||
56번째 줄: | 56번째 줄: | ||
values | values | ||
('새로_찾은_사진_001', '데이터베이스_수업1') | ('새로_찾은_사진_001', '데이터베이스_수업1') | ||
+ | </pre> |
2020년 11월 29일 (일) 14:17 기준 최신판
<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')