"인문정보데이터베이스20201022"의 두 판 사이의 차이

phj
이동: 둘러보기, 검색
18번째 줄: 18번째 줄:
 
  note nvarchar(256) NUll
 
  note nvarchar(256) NUll
 
  primary key(id)
 
  primary key(id)
−
)
+
)
 +
 
 +
*join 만들어보기
 +
use class2020
 +
 
 +
select * from institute
 +
select * from program
 +
select * from library
 +
select * from journal
 +
select * from person
 +
select * from affiliation
 +
 
 +
select institute_name, program_name from program
 +
join institute on program.institute_id=institute.institute_id
 +
where phd=1 and state_name='미국'

2020년 10월 22일 (목) 10:57 판

  • 이름 바꾸기
 use class2020
 select * from sys.tables
 select * from jdcDomainNode
 update jdcDomainNode set label=N'강녕전(康寧殿)' where id='강녕전'
 select * from jdcDomainNode
 where label like'%(%)'
  • table 만들기
create table jdcDomainNode(
id nvarchar(40) not NUll,  
class nvarchar(40)  NUll,
groupName nvarchar(40) NUll, 
partName nvarchar(40)  NUll,
label nvarchar(80) NUll, 
infoUrl nvarchar(256) NUll,
iconUrl nvarchar(256) NUll,
note nvarchar(256) NUll
primary key(id)
)
  • join 만들어보기

use class2020

select * from institute select * from program select * from library select * from journal select * from person select * from affiliation

select institute_name, program_name from program join institute on program.institute_id=institute.institute_id where phd=1 and state_name='미국'

원본 주소 "http://dh.aks.ac.kr/~phj/wiki/index.php?title=인문정보데이터베이스20201022&oldid=250"