"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 | ||
| + | <pre> | ||
/* | /* | ||
jdcDomainNode$ | jdcDomainNode$ | ||
| 55번째 줄: | 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')
