Re: 8월말 테스트 자료
작성자 정보
- 삼둡 작성
- 작성일
컨텐츠 정보
- 1,680 조회
- 목록
본문
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:46:40' WHERE herb='갈근';
insert into herbhistory set herb='갈근', event='단가변경', cost='18', comment='갈근:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:40';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:46:41' WHERE herb='감국';
insert into herbhistory set herb='감국', event='단가변경', cost='21', comment='감국:22 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:41';
UPDATE herb SET cost = 40, cost_date='2024-08-30 16:46:42' WHERE herb='감수';
insert into herbhistory set herb='감수', event='단가변경', cost='40', comment='감수:40 -> 40:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:42';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:46:43' WHERE herb='감초';
insert into herbhistory set herb='감초', event='단가변경', cost='28', comment='감초:28 -> 28:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:43';
UPDATE herb SET cost = 32, cost_date='2024-08-30 16:46:44' WHERE herb='강향';
insert into herbhistory set herb='강향', event='단가변경', cost='32', comment='강향:32 -> 32:전사분기 없어서 그 이전사분기(2023-2) 검색하여 단가책정', write_time='2024-08-30 16:46:44';
UPDATE herb SET cost = 59, cost_date='2024-08-30 16:46:45' WHERE herb='강활';
insert into herbhistory set herb='강활', event='단가변경', cost='59', comment='강활:58 -> 59:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:45';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:46:46' WHERE herb='강황';
insert into herbhistory set herb='강황', event='단가변경', cost='9', comment='강황:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:46';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:46:46' WHERE herb='갱미';
insert into herbhistory set herb='갱미', event='단가변경', cost='6', comment='갱미:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:46';
UPDATE herb SET cost = 48, cost_date='2024-08-30 16:46:50' WHERE herb='건강';
insert into herbhistory set herb='건강', event='단가변경', cost='48', comment='건강:48 -> 48:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:50';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:46:51' WHERE herb='건강초';
insert into herbhistory set herb='건강초', event='단가변경', cost='18', comment='건강초:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:51';
UPDATE herb SET cost = 29, cost_date='2024-08-30 16:46:52' WHERE herb='건율';
insert into herbhistory set herb='건율', event='단가변경', cost='29', comment='건율:29 -> 29:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:52';
UPDATE herb SET cost = 16, cost_date='2024-08-30 16:46:52' WHERE herb='건지황';
insert into herbhistory set herb='건지황', event='단가변경', cost='16', comment='건지황:17 -> 16:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:52';
UPDATE herb SET cost = 5, cost_date='2024-08-30 16:46:53' WHERE herb='결명자';
insert into herbhistory set herb='결명자', event='단가변경', cost='5', comment='결명자:5 -> 5:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:53';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:46:54' WHERE herb='계내금';
insert into herbhistory set herb='계내금', event='단가변경', cost='11', comment='계내금:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:54';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:46:54' WHERE herb='계지';
insert into herbhistory set herb='계지', event='단가변경', cost='6', comment='계지:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:54';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:46:55' WHERE herb='계혈등';
insert into herbhistory set herb='계혈등', event='단가변경', cost='6', comment='계혈등:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:55';
UPDATE herb SET cost = 70, cost_date='2024-08-30 16:46:56' WHERE herb='고본';
insert into herbhistory set herb='고본', event='단가변경', cost='70', comment='고본:70 -> 70:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:56';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:46:58' WHERE herb='고삼';
insert into herbhistory set herb='고삼', event='단가변경', cost='10', comment='고삼:10 -> 10:전사분기 없어서 그 이전사분기(2023-3) 검색하여 단가책정', write_time='2024-08-30 16:46:58';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:46:58' WHERE herb='골쇄보';
insert into herbhistory set herb='골쇄보', event='단가변경', cost='14', comment='골쇄보:15 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:46:58';
UPDATE herb SET cost = 32, cost_date='2024-08-30 16:47:00' WHERE herb='과루실';
insert into herbhistory set herb='과루실', event='단가변경', cost='32', comment='과루실:32 -> 32:전사분기 없어서 그 이전사분기(2023-3) 검색하여 단가책정', write_time='2024-08-30 16:47:00';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:47:00' WHERE herb='과루인';
insert into herbhistory set herb='과루인', event='단가변경', cost='10', comment='과루인:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:00';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:47:01' WHERE herb='곽향';
insert into herbhistory set herb='곽향', event='단가변경', cost='12', comment='곽향:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:01';
UPDATE herb SET cost = 150, cost_date='2024-08-30 16:47:02' WHERE herb='관동화';
insert into herbhistory set herb='관동화', event='단가변경', cost='150', comment='관동화:150 -> 150:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:02';
UPDATE herb SET cost = 29, cost_date='2024-08-30 16:47:02' WHERE herb='교이';
insert into herbhistory set herb='교이', event='단가변경', cost='29', comment='교이:29 -> 29:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:02';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:47:03' WHERE herb='구기자';
insert into herbhistory set herb='구기자', event='단가변경', cost='21', comment='구기자:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:03';
UPDATE herb SET cost = 50, cost_date='2024-08-30 16:47:05' WHERE herb='구인';
insert into herbhistory set herb='구인', event='단가변경', cost='50', comment='구인:50 -> 50:전사분기 없어서 그 이전사분기(2023-1) 검색하여 단가책정', write_time='2024-08-30 16:47:05';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:47:06' WHERE herb='구척';
insert into herbhistory set herb='구척', event='단가변경', cost='8', comment='구척:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:06';
UPDATE herb SET cost = 150, cost_date='2024-08-30 16:47:07' WHERE herb='구판교';
insert into herbhistory set herb='구판교', event='단가변경', cost='150', comment='구판교:150 -> 150:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:07';
UPDATE herb SET cost = 58, cost_date='2024-08-30 16:47:08' WHERE herb='귤피';
insert into herbhistory set herb='귤피', event='단가변경', cost='58', comment='귤피:58 -> 58:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:47:08';
UPDATE herb SET cost = 55, cost_date='2024-08-30 16:47:09' WHERE herb='금은화';
insert into herbhistory set herb='금은화', event='단가변경', cost='55', comment='금은화:55 -> 55:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:09';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:47:09' WHERE herb='길경';
insert into herbhistory set herb='길경', event='단가변경', cost='14', comment='길경:14 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:09';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:47:10' WHERE herb='나복자';
insert into herbhistory set herb='나복자', event='단가변경', cost='8', comment='나복자:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:10';
UPDATE herb SET cost = 26, cost_date='2024-08-30 16:47:11' WHERE herb='남성';
insert into herbhistory set herb='남성', event='단가변경', cost='26', comment='남성:26 -> 26:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:47:11';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:47:12' WHERE herb='노로통';
insert into herbhistory set herb='노로통', event='단가변경', cost='10', comment='노로통:10 -> 10:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:47:12';
UPDATE herb SET cost = 86, cost_date='2024-08-30 16:47:14' WHERE herb='녹각';
insert into herbhistory set herb='녹각', event='단가변경', cost='86', comment='녹각:86 -> 86:전사분기 없어서 그 이전사분기(2023-3) 검색하여 단가책정', write_time='2024-08-30 16:47:14';
UPDATE herb SET cost = 100, cost_date='2024-08-30 16:47:14' WHERE herb='녹각교';
insert into herbhistory set herb='녹각교', event='단가변경', cost='100', comment='녹각교:100 -> 100:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:14';
UPDATE herb SET cost = 1467, cost_date='2024-08-30 16:47:15' WHERE herb='녹용분골';
insert into herbhistory set herb='녹용분골', event='단가변경', cost='1467', comment='녹용분골:1467 -> 1467:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:15';
UPDATE herb SET cost = 967, cost_date='2024-08-30 16:47:16' WHERE herb='녹용상대';
insert into herbhistory set herb='녹용상대', event='단가변경', cost='967', comment='녹용상대:967 -> 967:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:16';
UPDATE herb SET cost = 500, cost_date='2024-08-30 16:47:16' WHERE herb='녹용중대';
insert into herbhistory set herb='녹용중대', event='단가변경', cost='500', comment='녹용중대:500 -> 500:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:16';
UPDATE herb SET cost = 767, cost_date='2024-08-30 16:47:17' WHERE herb='뉴분골';
insert into herbhistory set herb='뉴분골', event='단가변경', cost='767', comment='뉴분골:767 -> 767:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:17';
UPDATE herb SET cost = 600, cost_date='2024-08-30 16:47:18' WHERE herb='뉴상대';
insert into herbhistory set herb='뉴상대', event='단가변경', cost='600', comment='뉴상대:600 -> 600:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:18';
UPDATE herb SET cost = 417, cost_date='2024-08-30 16:47:19' WHERE herb='뉴중대';
insert into herbhistory set herb='뉴중대', event='단가변경', cost='417', comment='뉴중대:417 -> 417:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:19';
UPDATE herb SET cost = 15, cost_date='2024-08-30 16:47:19' WHERE herb='단삼';
insert into herbhistory set herb='단삼', event='단가변경', cost='15', comment='단삼:15 -> 15:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:19';
UPDATE herb SET cost = 31, cost_date='2024-08-30 16:47:21' WHERE herb='담두시';
insert into herbhistory set herb='담두시', event='단가변경', cost='31', comment='담두시:31 -> 31:전사분기 없어서 그 이전사분기(2023-2) 검색하여 단가책정', write_time='2024-08-30 16:47:21';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:47:22' WHERE herb='당귀';
insert into herbhistory set herb='당귀', event='단가변경', cost='28', comment='당귀:28 -> 28:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:22';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:47:23' WHERE herb='당귀2';
insert into herbhistory set herb='당귀2', event='단가변경', cost='21', comment='당귀2:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:23';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:47:23' WHERE herb='당귀미';
insert into herbhistory set herb='당귀미', event='단가변경', cost='21', comment='당귀미:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:23';
UPDATE herb SET cost = 48, cost_date='2024-08-30 16:47:24' WHERE herb='당귀신';
insert into herbhistory set herb='당귀신', event='단가변경', cost='48', comment='당귀신:48 -> 48:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:24';
UPDATE herb SET cost = 55, cost_date='2024-08-30 16:47:25' WHERE herb='당삼';
insert into herbhistory set herb='당삼', event='단가변경', cost='55', comment='당삼:55 -> 55:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:25';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:47:25' WHERE herb='대계초';
insert into herbhistory set herb='대계초', event='단가변경', cost='22', comment='대계초:22 -> 22:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:25';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:47:26' WHERE herb='대복피';
insert into herbhistory set herb='대복피', event='단가변경', cost='6', comment='대복피:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:26';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:47:27' WHERE herb='대조';
insert into herbhistory set herb='대조', event='단가변경', cost='20', comment='대조:20 -> 20:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:27';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:47:28' WHERE herb='대황';
insert into herbhistory set herb='대황', event='단가변경', cost='10', comment='대황:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:28';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:47:28' WHERE herb='대황주증';
insert into herbhistory set herb='대황주증', event='단가변경', cost='19', comment='대황주증:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:28';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:47:29' WHERE herb='도인';
insert into herbhistory set herb='도인', event='단가변경', cost='12', comment='도인:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:29';
UPDATE herb SET cost = 33, cost_date='2024-08-30 16:47:30' WHERE herb='독활';
insert into herbhistory set herb='독활', event='단가변경', cost='33', comment='독활:33 -> 33:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:30';
UPDATE herb SET cost = 26, cost_date='2024-08-30 16:47:34' WHERE herb='두충';
insert into herbhistory set herb='두충', event='단가변경', cost='26', comment='두충:26 -> 26:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:34';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:47:34' WHERE herb='두충염초';
insert into herbhistory set herb='두충염초', event='단가변경', cost='17', comment='두충염초:17 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:34';
UPDATE herb SET cost = 65, cost_date='2024-08-30 16:47:35' WHERE herb='등심';
insert into herbhistory set herb='등심', event='단가변경', cost='65', comment='등심:65 -> 65:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:35';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:47:37' WHERE herb='마자인';
insert into herbhistory set herb='마자인', event='단가변경', cost='9', comment='마자인:9 -> 9:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:47:37';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:47:37' WHERE herb='마황';
insert into herbhistory set herb='마황', event='단가변경', cost='11', comment='마황:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:37';
UPDATE herb SET cost = 34, cost_date='2024-08-30 16:47:38' WHERE herb='만형자';
insert into herbhistory set herb='만형자', event='단가변경', cost='34', comment='만형자:34 -> 34:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:38';
UPDATE herb SET cost = 5, cost_date='2024-08-30 16:47:39' WHERE herb='망초';
insert into herbhistory set herb='망초', event='단가변경', cost='5', comment='망초:5 -> 5:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:39';
UPDATE herb SET cost = 71, cost_date='2024-08-30 16:47:39' WHERE herb='맥문동';
insert into herbhistory set herb='맥문동', event='단가변경', cost='71', comment='맥문동:71 -> 71:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:39';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:47:40' WHERE herb='맥아';
insert into herbhistory set herb='맥아', event='단가변경', cost='8', comment='맥아:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:40';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:47:41' WHERE herb='모려';
insert into herbhistory set herb='모려', event='단가변경', cost='8', comment='모려:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:41';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:47:41' WHERE herb='목과';
insert into herbhistory set herb='목과', event='단가변경', cost='11', comment='목과:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:41';
UPDATE herb SET cost = 37, cost_date='2024-08-30 16:47:42' WHERE herb='목단피';
insert into herbhistory set herb='목단피', event='단가변경', cost='37', comment='목단피:37 -> 37:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:42';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:47:43' WHERE herb='목통';
insert into herbhistory set herb='목통', event='단가변경', cost='11', comment='목통:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:43';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:47:44' WHERE herb='목향';
insert into herbhistory set herb='목향', event='단가변경', cost='11', comment='목향:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:44';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:47:44' WHERE herb='몰약';
insert into herbhistory set herb='몰약', event='단가변경', cost='18', comment='몰약:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:44';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:47:45' WHERE herb='박하';
insert into herbhistory set herb='박하', event='단가변경', cost='12', comment='박하:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:45';
UPDATE herb SET cost = 48, cost_date='2024-08-30 16:47:46' WHERE herb='반하';
insert into herbhistory set herb='반하', event='단가변경', cost='48', comment='반하:48 -> 48:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:46';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:47:47' WHERE herb='방기';
insert into herbhistory set herb='방기', event='단가변경', cost='6', comment='방기:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:47';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:47:47' WHERE herb='방풍';
insert into herbhistory set herb='방풍', event='단가변경', cost='18', comment='방풍:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:47';
UPDATE herb SET cost = 43, cost_date='2024-08-30 16:47:48' WHERE herb='백강잠';
insert into herbhistory set herb='백강잠', event='단가변경', cost='43', comment='백강잠:43 -> 43:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:48';
UPDATE herb SET cost = 5, cost_date='2024-08-30 16:47:51' WHERE herb='백개자';
insert into herbhistory set herb='백개자', event='단가변경', cost='5', comment='백개자:5 -> 5:전사분기 없어서 그 이전사분기(2022-3) 검색하여 단가책정', write_time='2024-08-30 16:47:51';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:47:51' WHERE herb='백과';
insert into herbhistory set herb='백과', event='단가변경', cost='19', comment='백과:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:51';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:47:54' WHERE herb='백단향';
insert into herbhistory set herb='백단향', event='단가변경', cost='17', comment='백단향:17 -> 17:전사분기 없어서 그 이전사분기(2023-1) 검색하여 단가책정', write_time='2024-08-30 16:47:54';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:47:54' WHERE herb='백두구';
insert into herbhistory set herb='백두구', event='단가변경', cost='21', comment='백두구:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:54';
UPDATE herb SET cost = 56, cost_date='2024-08-30 16:47:55' WHERE herb='백선피';
insert into herbhistory set herb='백선피', event='단가변경', cost='56', comment='백선피:56 -> 56:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:55';
UPDATE herb SET cost = 54, cost_date='2024-08-30 16:47:55' WHERE herb='백수오';
insert into herbhistory set herb='백수오', event='단가변경', cost='54', comment='백수오:54 -> 54:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:55';
UPDATE herb SET cost = 52, cost_date='2024-08-30 16:47:56' WHERE herb='백자인';
insert into herbhistory set herb='백자인', event='단가변경', cost='52', comment='백자인:52 -> 52:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:56';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:47:57' WHERE herb='백지';
insert into herbhistory set herb='백지', event='단가변경', cost='28', comment='백지:28 -> 28:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:57';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:47:58' WHERE herb='백질려';
insert into herbhistory set herb='백질려', event='단가변경', cost='17', comment='백질려:17 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:58';
UPDATE herb SET cost = 30, cost_date='2024-08-30 16:47:58' WHERE herb='백출';
insert into herbhistory set herb='백출', event='단가변경', cost='30', comment='백출:30 -> 30:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:58';
UPDATE herb SET cost = 30, cost_date='2024-08-30 16:47:59' WHERE herb='백출초';
insert into herbhistory set herb='백출초', event='단가변경', cost='30', comment='백출초:30 -> 30:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:47:59';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:01' WHERE herb='백편두';
insert into herbhistory set herb='백편두', event='단가변경', cost='9', comment='백편두:9 -> 9:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:48:01';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:48:01' WHERE herb='복령';
insert into herbhistory set herb='복령', event='단가변경', cost='13', comment='복령:13 -> 13:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:01';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:48:02' WHERE herb='복분자';
insert into herbhistory set herb='복분자', event='단가변경', cost='10', comment='복분자:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:02';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:48:03' WHERE herb='봉출';
insert into herbhistory set herb='봉출', event='단가변경', cost='12', comment='봉출:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:03';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:48:03' WHERE herb='부소맥';
insert into herbhistory set herb='부소맥', event='단가변경', cost='11', comment='부소맥:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:03';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:48:04' WHERE herb='부자';
insert into herbhistory set herb='부자', event='단가변경', cost='19', comment='부자:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:04';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:48:05' WHERE herb='부평초';
insert into herbhistory set herb='부평초', event='단가변경', cost='11', comment='부평초:11 -> 11:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:48:05';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:48:09' WHERE herb='비파엽';
insert into herbhistory set herb='비파엽', event='단가변경', cost='8', comment='비파엽:8 -> 8:전사분기 없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:48:09';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:09' WHERE herb='빈랑';
insert into herbhistory set herb='빈랑', event='단가변경', cost='9', comment='빈랑:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:09';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:48:12' WHERE herb='사간';
insert into herbhistory set herb='사간', event='단가변경', cost='20', comment='사간:20 -> 20:전사분기 없어서 그 이전사분기(2022-2) 검색하여 단가책정', write_time='2024-08-30 16:48:12';
UPDATE herb SET cost = 44, cost_date='2024-08-30 16:48:12' WHERE herb='사삼';
insert into herbhistory set herb='사삼', event='단가변경', cost='44', comment='사삼:44 -> 44:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:12';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:48:16' WHERE herb='사인';
insert into herbhistory set herb='사인', event='단가변경', cost='23', comment='사인:23 -> 23:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:16';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:48:17' WHERE herb='산사';
insert into herbhistory set herb='산사', event='단가변경', cost='8', comment='산사:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:17';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:18' WHERE herb='산사초';
insert into herbhistory set herb='산사초', event='단가변경', cost='9', comment='산사초:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:18';
UPDATE herb SET cost = 35, cost_date='2024-08-30 16:48:18' WHERE herb='산수유';
insert into herbhistory set herb='산수유', event='단가변경', cost='35', comment='산수유:35 -> 35:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:18';
UPDATE herb SET cost = 45, cost_date='2024-08-30 16:48:19' WHERE herb='산약';
insert into herbhistory set herb='산약', event='단가변경', cost='45', comment='산약:45 -> 45:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:19';
UPDATE herb SET cost = 45, cost_date='2024-08-30 16:48:20' WHERE herb='산약초';
insert into herbhistory set herb='산약초', event='단가변경', cost='45', comment='산약초:45 -> 45:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:48:20';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:21' WHERE herb='삼릉';
insert into herbhistory set herb='삼릉', event='단가변경', cost='9', comment='삼릉:9 -> 9:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:48:21';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:48:22' WHERE herb='삼백초';
insert into herbhistory set herb='삼백초', event='단가변경', cost='20', comment='삼백초:20 -> 20:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:22';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:48:25' WHERE herb='상기생';
insert into herbhistory set herb='상기생', event='단가변경', cost='10', comment='상기생:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:25';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:48:26' WHERE herb='상백피';
insert into herbhistory set herb='상백피', event='단가변경', cost='12', comment='상백피:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:26';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:48:27' WHERE herb='상심자';
insert into herbhistory set herb='상심자', event='단가변경', cost='21', comment='상심자:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:27';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:48:31' WHERE herb='상지';
insert into herbhistory set herb='상지', event='단가변경', cost='8', comment='상지:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:31';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:48:31' WHERE herb='생강';
insert into herbhistory set herb='생강', event='단가변경', cost='17', comment='생강:17 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:31';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:48:32' WHERE herb='생지황';
insert into herbhistory set herb='생지황', event='단가변경', cost='18', comment='생지황:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:32';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:48:42' WHERE herb='석결명';
insert into herbhistory set herb='석결명', event='단가변경', cost='10', comment='석결명:10 -> 10:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:48:42';
UPDATE herb SET cost = 4, cost_date='2024-08-30 16:48:43' WHERE herb='석고';
insert into herbhistory set herb='석고', event='단가변경', cost='4', comment='석고:4 -> 4:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:43';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:48:43' WHERE herb='석곡';
insert into herbhistory set herb='석곡', event='단가변경', cost='22', comment='석곡:22 -> 22:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:43';
UPDATE herb SET cost = 33, cost_date='2024-08-30 16:48:44' WHERE herb='석창포';
insert into herbhistory set herb='석창포', event='단가변경', cost='33', comment='석창포:33 -> 33:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:44';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:48:47' WHERE herb='선모';
insert into herbhistory set herb='선모', event='단가변경', cost='23', comment='선모:23 -> 23:전사분기 없어서 그 이전사분기(2022-4) 검색하여 단가책정', write_time='2024-08-30 16:48:47';
UPDATE herb SET cost = 150, cost_date='2024-08-30 16:48:47' WHERE herb='선퇴';
insert into herbhistory set herb='선퇴', event='단가변경', cost='150', comment='선퇴:150 -> 150:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:47';
UPDATE herb SET cost = 131, cost_date='2024-08-30 16:48:48' WHERE herb='세신';
insert into herbhistory set herb='세신', event='단가변경', cost='131', comment='세신:131 -> 131:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:48';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:48:49' WHERE herb='소목';
insert into herbhistory set herb='소목', event='단가변경', cost='6', comment='소목:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:49';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:48:51' WHERE herb='소자';
insert into herbhistory set herb='소자', event='단가변경', cost='12', comment='소자:12 -> 12:전사분기 없어서 그 이전사분기(2023-2) 검색하여 단가책정', write_time='2024-08-30 16:48:51';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:51' WHERE herb='소회향';
insert into herbhistory set herb='소회향', event='단가변경', cost='9', comment='소회향:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:51';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:48:52' WHERE herb='속단';
insert into herbhistory set herb='속단', event='단가변경', cost='13', comment='속단:13 -> 13:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:52';
UPDATE herb SET cost = 39, cost_date='2024-08-30 16:48:52' WHERE herb='쇄양';
insert into herbhistory set herb='쇄양', event='단가변경', cost='39', comment='쇄양:22 -> 39:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:52';
UPDATE herb SET cost = 53, cost_date='2024-08-30 16:48:53' WHERE herb='숙지황';
insert into herbhistory set herb='숙지황', event='단가변경', cost='53', comment='숙지황:53 -> 53:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:53';
UPDATE herb SET cost = 36, cost_date='2024-08-30 16:48:54' WHERE herb='승마';
insert into herbhistory set herb='승마', event='단가변경', cost='36', comment='승마:36 -> 36:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:54';
UPDATE herb SET cost = 35, cost_date='2024-08-30 16:48:56' WHERE herb='승마주초';
insert into herbhistory set herb='승마주초', event='단가변경', cost='35', comment='승마주초:35 -> 35:전사분기 없어서 그 이전사분기(2022-4) 검색하여 단가책정', write_time='2024-08-30 16:48:56';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:48:57' WHERE herb='시호';
insert into herbhistory set herb='시호', event='단가변경', cost='18', comment='시호:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:57';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:48:58' WHERE herb='신곡';
insert into herbhistory set herb='신곡', event='단가변경', cost='9', comment='신곡:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:58';
UPDATE herb SET cost = 32, cost_date='2024-08-30 16:48:58' WHERE herb='신이화';
insert into herbhistory set herb='신이화', event='단가변경', cost='32', comment='신이화:32 -> 32:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:48:58';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:49:02' WHERE herb='아교주';
insert into herbhistory set herb='아교주', event='단가변경', cost='27', comment='아교주:27 -> 27:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:02';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:49:03' WHERE herb='애엽';
insert into herbhistory set herb='애엽', event='단가변경', cost='12', comment='애엽:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:03';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:49:04' WHERE herb='야교등';
insert into herbhistory set herb='야교등', event='단가변경', cost='10', comment='야교등:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:04';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:49:05' WHERE herb='양강';
insert into herbhistory set herb='양강', event='단가변경', cost='21', comment='양강:21 -> 21:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:49:05';
UPDATE herb SET cost = 24, cost_date='2024-08-30 16:49:05' WHERE herb='어성초';
insert into herbhistory set herb='어성초', event='단가변경', cost='24', comment='어성초:24 -> 24:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:05';
UPDATE herb SET cost = 54, cost_date='2024-08-30 16:49:09' WHERE herb='연교';
insert into herbhistory set herb='연교', event='단가변경', cost='54', comment='연교:58 -> 54:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:09';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:49:10' WHERE herb='연자육';
insert into herbhistory set herb='연자육', event='단가변경', cost='8', comment='연자육:8 -> 8:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:10';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:49:11' WHERE herb='오가피';
insert into herbhistory set herb='오가피', event='단가변경', cost='19', comment='오가피:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:11';
UPDATE herb SET cost = 929, cost_date='2024-08-30 16:49:14' WHERE herb='오공';
insert into herbhistory set herb='오공', event='단가변경', cost='929', comment='오공:929 -> 929:전사분기 없어서 그 이전사분기(2022-1) 검색하여 단가책정', write_time='2024-08-30 16:49:14';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:49:16' WHERE herb='오령지';
insert into herbhistory set herb='오령지', event='단가변경', cost='18', comment='오령지:18 -> 18:전사분기 없어서 그 이전사분기(2022-4) 검색하여 단가책정', write_time='2024-08-30 16:49:16';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:49:17' WHERE herb='오매';
insert into herbhistory set herb='오매', event='단가변경', cost='13', comment='오매:14 -> 13:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:17';
UPDATE herb SET cost = 81, cost_date='2024-08-30 16:49:17' WHERE herb='오미자';
insert into herbhistory set herb='오미자', event='단가변경', cost='81', comment='오미자:81 -> 81:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:17';
UPDATE herb SET cost = 24, cost_date='2024-08-30 16:49:18' WHERE herb='오수유';
insert into herbhistory set herb='오수유', event='단가변경', cost='24', comment='오수유:24 -> 24:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:18';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:49:19' WHERE herb='오약';
insert into herbhistory set herb='오약', event='단가변경', cost='11', comment='오약:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:19';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:49:21' WHERE herb='옥촉서예';
insert into herbhistory set herb='옥촉서예', event='단가변경', cost='12', comment='옥촉서예:12 -> 12:전사분기 없어서 그 이전사분기(2023-2) 검색하여 단가책정', write_time='2024-08-30 16:49:21';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:49:25' WHERE herb='왕불유행';
insert into herbhistory set herb='왕불유행', event='단가변경', cost='20', comment='왕불유행:20 -> 20:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:49:25';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:49:25' WHERE herb='용골';
insert into herbhistory set herb='용골', event='단가변경', cost='14', comment='용골:14 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:25';
UPDATE herb SET cost = 42, cost_date='2024-08-30 16:49:28' WHERE herb='용담초';
insert into herbhistory set herb='용담초', event='단가변경', cost='42', comment='용담초:42 -> 42:전사분기 없어서 그 이전사분기(2022-4) 검색하여 단가책정', write_time='2024-08-30 16:49:28';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:49:28' WHERE herb='용안육';
insert into herbhistory set herb='용안육', event='단가변경', cost='21', comment='용안육:21 -> 21:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:28';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:49:29' WHERE herb='우방자';
insert into herbhistory set herb='우방자', event='단가변경', cost='13', comment='우방자:14 -> 13:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:29';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:49:30' WHERE herb='우슬';
insert into herbhistory set herb='우슬', event='단가변경', cost='14', comment='우슬:14 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:30';
UPDATE herb SET cost = 15, cost_date='2024-08-30 16:49:31' WHERE herb='우슬주초';
insert into herbhistory set herb='우슬주초', event='단가변경', cost='15', comment='우슬주초:15 -> 15:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:31';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:49:34' WHERE herb='욱리인';
insert into herbhistory set herb='욱리인', event='단가변경', cost='22', comment='욱리인:22 -> 22:전사분기 없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:49:34';
UPDATE herb SET cost = 350, cost_date='2024-08-30 16:49:36' WHERE herb='원산조인';
insert into herbhistory set herb='원산조인', event='단가변경', cost='350', comment='원산조인:350 -> 350:전사분기 없어서 그 이전사분기(2023-2) 검색하여 단가책정', write_time='2024-08-30 16:49:36';
UPDATE herb SET cost = 333, cost_date='2024-08-30 16:49:36' WHERE herb='원산조인초';
insert into herbhistory set herb='원산조인초', event='단가변경', cost='333', comment='원산조인초:333 -> 333:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:36';
UPDATE herb SET cost = 93, cost_date='2024-08-30 16:49:37' WHERE herb='원지';
insert into herbhistory set herb='원지', event='단가변경', cost='93', comment='원지:93 -> 93:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:37';
UPDATE herb SET cost = 96, cost_date='2024-08-30 16:49:38' WHERE herb='원지초';
insert into herbhistory set herb='원지초', event='단가변경', cost='96', comment='원지초:96 -> 96:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:38';
UPDATE herb SET cost = 33, cost_date='2024-08-30 16:49:38' WHERE herb='위령선';
insert into herbhistory set herb='위령선', event='단가변경', cost='33', comment='위령선:33 -> 33:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:38';
UPDATE herb SET cost = 39, cost_date='2024-08-30 16:49:40' WHERE herb='유근피';
insert into herbhistory set herb='유근피', event='단가변경', cost='39', comment='유근피:39 -> 39:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:49:40';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:49:40' WHERE herb='유향';
insert into herbhistory set herb='유향', event='단가변경', cost='14', comment='유향:14 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:40';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:49:41' WHERE herb='육계';
insert into herbhistory set herb='육계', event='단가변경', cost='12', comment='육계:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:41';
UPDATE herb SET cost = 26, cost_date='2024-08-30 16:49:45' WHERE herb='육종용';
insert into herbhistory set herb='육종용', event='단가변경', cost='26', comment='육종용:26 -> 26:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:45';
UPDATE herb SET cost = 32, cost_date='2024-08-30 16:49:45' WHERE herb='음양곽';
insert into herbhistory set herb='음양곽', event='단가변경', cost='32', comment='음양곽:32 -> 32:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:45';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:49:46' WHERE herb='의이인거피';
insert into herbhistory set herb='의이인거피', event='단가변경', cost='17', comment='의이인거피:17 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:46';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:49:50' WHERE herb='익모초';
insert into herbhistory set herb='익모초', event='단가변경', cost='12', comment='익모초:13 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:50';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:49:50' WHERE herb='익지인';
insert into herbhistory set herb='익지인', event='단가변경', cost='18', comment='익지인:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:50';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:49:51' WHERE herb='인동등';
insert into herbhistory set herb='인동등', event='단가변경', cost='19', comment='인동등:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:51';
UPDATE herb SET cost = 108, cost_date='2024-08-30 16:49:52' WHERE herb='인삼';
insert into herbhistory set herb='인삼', event='단가변경', cost='108', comment='인삼:108 -> 108:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:52';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:49:53' WHERE herb='인진호';
insert into herbhistory set herb='인진호', event='단가변경', cost='13', comment='인진호:13 -> 13:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:53';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:49:53' WHERE herb='자감초';
insert into herbhistory set herb='자감초', event='단가변경', cost='28', comment='자감초:28 -> 28:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:53';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:49:54' WHERE herb='자소엽';
insert into herbhistory set herb='자소엽', event='단가변경', cost='14', comment='자소엽:14 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:54';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:49:56' WHERE herb='자완';
insert into herbhistory set herb='자완', event='단가변경', cost='23', comment='자완:23 -> 23:전사분기 없어서 그 이전사분기(2023-1) 검색하여 단가책정', write_time='2024-08-30 16:49:56';
UPDATE herb SET cost = 660, cost_date='2024-08-30 16:49:57' WHERE herb='자하거';
insert into herbhistory set herb='자하거', event='단가변경', cost='660', comment='자하거:750 -> 660:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:57';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:49:58' WHERE herb='작약';
insert into herbhistory set herb='작약', event='단가변경', cost='18', comment='작약:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:58';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:49:58' WHERE herb='작약주초';
insert into herbhistory set herb='작약주초', event='단가변경', cost='22', comment='작약주초:22 -> 22:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:58';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:49:59' WHERE herb='작약초';
insert into herbhistory set herb='작약초', event='단가변경', cost='22', comment='작약초:22 -> 22:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:49:59';
UPDATE herb SET cost = 46, cost_date='2024-08-30 16:50:00' WHERE herb='저령';
insert into herbhistory set herb='저령', event='단가변경', cost='46', comment='저령:46 -> 46:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:00';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:50:01' WHERE herb='적복령';
insert into herbhistory set herb='적복령', event='단가변경', cost='27', comment='적복령:27 -> 27:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:01';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:50:01' WHERE herb='적작약';
insert into herbhistory set herb='적작약', event='단가변경', cost='28', comment='적작약:28 -> 28:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:01';
UPDATE herb SET cost = 400, cost_date='2024-08-30 16:50:03' WHERE herb='전충';
insert into herbhistory set herb='전충', event='단가변경', cost='400', comment='전충:400 -> 400:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:50:03';
UPDATE herb SET cost = 40, cost_date='2024-08-30 16:50:03' WHERE herb='전호';
insert into herbhistory set herb='전호', event='단가변경', cost='40', comment='전호:40 -> 40:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:03';
UPDATE herb SET cost = 7, cost_date='2024-08-30 16:50:06' WHERE herb='정력자';
insert into herbhistory set herb='정력자', event='단가변경', cost='7', comment='정력자:7 -> 7:전사분기 없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:50:06';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:50:10' WHERE herb='조각자';
insert into herbhistory set herb='조각자', event='단가변경', cost='19', comment='조각자:19 -> 19:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:10';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:11' WHERE herb='조구등';
insert into herbhistory set herb='조구등', event='단가변경', cost='18', comment='조구등:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:11';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:50:11' WHERE herb='죽여';
insert into herbhistory set herb='죽여', event='단가변경', cost='17', comment='죽여:17 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:11';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:50:12' WHERE herb='지각';
insert into herbhistory set herb='지각', event='단가변경', cost='11', comment='지각:11 -> 11:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:12';
UPDATE herb SET cost = 30, cost_date='2024-08-30 16:50:13' WHERE herb='지골피';
insert into herbhistory set herb='지골피', event='단가변경', cost='30', comment='지골피:30 -> 30:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:13';
UPDATE herb SET cost = 6, cost_date='2024-08-30 16:50:14' WHERE herb='지구자';
insert into herbhistory set herb='지구자', event='단가변경', cost='6', comment='지구자:6 -> 6:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:14';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:14' WHERE herb='지모';
insert into herbhistory set herb='지모', event='단가변경', cost='18', comment='지모:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:14';
UPDATE herb SET cost = 22, cost_date='2024-08-30 16:50:15' WHERE herb='지모초';
insert into herbhistory set herb='지모초', event='단가변경', cost='22', comment='지모초:22 -> 22:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:15';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:50:18' WHERE herb='지부자';
insert into herbhistory set herb='지부자', event='단가변경', cost='8', comment='지부자:8 -> 8:전사분기 없어서 그 이전사분기(2022-1) 검색하여 단가책정', write_time='2024-08-30 16:50:18';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:50:19' WHERE herb='지실';
insert into herbhistory set herb='지실', event='단가변경', cost='23', comment='지실:23 -> 23:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:19';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:50:20' WHERE herb='지유';
insert into herbhistory set herb='지유', event='단가변경', cost='10', comment='지유:10 -> 10:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:50:20';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:50:20' WHERE herb='진범';
insert into herbhistory set herb='진범', event='단가변경', cost='23', comment='진범:23 -> 23:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:20';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:50:21' WHERE herb='진피';
insert into herbhistory set herb='진피', event='단가변경', cost='12', comment='진피:11 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:21';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:50:22' WHERE herb='차전자';
insert into herbhistory set herb='차전자', event='단가변경', cost='12', comment='차전자:12 -> 12:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:22';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:50:23' WHERE herb='창이자';
insert into herbhistory set herb='창이자', event='단가변경', cost='8', comment='창이자:8 -> 8:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:50:23';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:50:24' WHERE herb='창출';
insert into herbhistory set herb='창출', event='단가변경', cost='27', comment='창출:27 -> 27:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:24';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:50:24' WHERE herb='천궁';
insert into herbhistory set herb='천궁', event='단가변경', cost='23', comment='천궁:23 -> 23:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:24';
UPDATE herb SET cost = 61, cost_date='2024-08-30 16:50:26' WHERE herb='천궁토';
insert into herbhistory set herb='천궁토', event='단가변경', cost='61', comment='천궁토:61 -> 61:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:50:26';
UPDATE herb SET cost = 43, cost_date='2024-08-30 16:50:29' WHERE herb='천마';
insert into herbhistory set herb='천마', event='단가변경', cost='43', comment='천마:43 -> 43:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:29';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:50:30' WHERE herb='천문동';
insert into herbhistory set herb='천문동', event='단가변경', cost='27', comment='천문동:27 -> 27:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:30';
UPDATE herb SET cost = 30, cost_date='2024-08-30 16:50:33' WHERE herb='천초';
insert into herbhistory set herb='천초', event='단가변경', cost='30', comment='천초:30 -> 30:전사분기 없어서 그 이전사분기(2022-2) 검색하여 단가책정', write_time='2024-08-30 16:50:33';
UPDATE herb SET cost = 25, cost_date='2024-08-30 16:50:33' WHERE herb='천화분';
insert into herbhistory set herb='천화분', event='단가변경', cost='25', comment='천화분:25 -> 25:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:33';
UPDATE herb SET cost = 9, cost_date='2024-08-30 16:50:34' WHERE herb='청피';
insert into herbhistory set herb='청피', event='단가변경', cost='9', comment='청피:9 -> 9:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:34';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:50:36' WHERE herb='초과';
insert into herbhistory set herb='초과', event='단가변경', cost='21', comment='초과:21 -> 21:전사분기 없어서 그 이전사분기(2023-4) 검색하여 단가책정', write_time='2024-08-30 16:50:36';
UPDATE herb SET cost = 13, cost_date='2024-08-30 16:50:37' WHERE herb='초두구';
insert into herbhistory set herb='초두구', event='단가변경', cost='13', comment='초두구:13 -> 13:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:50:37';
UPDATE herb SET cost = 40, cost_date='2024-08-30 16:50:37' WHERE herb='총백';
insert into herbhistory set herb='총백', event='단가변경', cost='40', comment='총백:40 -> 40:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:37';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:50:38' WHERE herb='치자';
insert into herbhistory set herb='치자', event='단가변경', cost='14', comment='치자:13 -> 14:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:38';
UPDATE herb SET cost = 17, cost_date='2024-08-30 16:50:39' WHERE herb='치자초';
insert into herbhistory set herb='치자초', event='단가변경', cost='17', comment='치자초:16 -> 17:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:39';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:39' WHERE herb='택란';
insert into herbhistory set herb='택란', event='단가변경', cost='18', comment='택란:18 -> 18:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:39';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:50:40' WHERE herb='택사';
insert into herbhistory set herb='택사', event='단가변경', cost='27', comment='택사:27 -> 27:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:40';
UPDATE herb SET cost = 19, cost_date='2024-08-30 16:50:41' WHERE herb='토복령';
insert into herbhistory set herb='토복령', event='단가변경', cost='19', comment='토복령:19 -> 19:전사분기 없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:50:41';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:50:42' WHERE herb='토사자';
insert into herbhistory set herb='토사자', event='단가변경', cost='20', comment='토사자:20 -> 20:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:42';
UPDATE herb SET cost = 10, cost_date='2024-08-30 16:50:45' WHERE herb='파고지';
insert into herbhistory set herb='파고지', event='단가변경', cost='10', comment='파고지:10 -> 10:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:45';
UPDATE herb SET cost = 52, cost_date='2024-08-30 16:50:48' WHERE herb='파극';
insert into herbhistory set herb='파극', event='단가변경', cost='52', comment='파극:52 -> 52:전사분기 없어서 그 이전사분기(2022-4) 검색하여 단가책정', write_time='2024-08-30 16:50:48';
UPDATE herb SET cost = 37, cost_date='2024-08-30 16:50:48' WHERE herb='패모';
insert into herbhistory set herb='패모', event='단가변경', cost='37', comment='패모:37 -> 37:전사분기(2024-2) 고려 단가변경', write_time='2024-08-30 16:50:48';
UPDATE herb SET cost = 21, cost_date='2024-08-30 16:50:52' WHERE herb='포공영';
insert into herbhistory set herb='포공영', event='단가변경', cost='21', comment='포공영:21 -> 21:전사분기 없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:50:52';
UPDATE herb
관련자료
-
이전작성일 2024.06.25 16:36
-
다음