Re: Re: 8월말 테스트 자료 #2

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 SET cost = 23, cost_date='2024-08-30 16:50:54'  WHERE herb='포황';
insert into herbhistory set herb='포황', event='단가변경', cost='23', comment='포황:23 -> 23:전사분기  없어서 그 이전사분기(2022-3) 검색하여 단가책정', write_time='2024-08-30 16:50:54';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:55' WHERE herb='하고초';
insert into herbhistory set herb='하고초', event='단가변경', cost='18', comment='하고초:18 -> 18:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:50:55';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:50:56' WHERE herb='하수오';
insert into herbhistory set herb='하수오', event='단가변경', cost='11', comment='하수오:11 -> 11:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:50:56';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:59'  WHERE herb='한련초';
insert into herbhistory set herb='한련초', event='단가변경', cost='18', comment='한련초:18 -> 18:전사분기  없어서 그 이전사분기(2022-1) 검색하여 단가책정', write_time='2024-08-30 16:50:59';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:50:59' WHERE herb='합환피';
insert into herbhistory set herb='합환피', event='단가변경', cost='18', comment='합환피:18 -> 18:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:50:59';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:51:00' WHERE herb='해동피';
insert into herbhistory set herb='해동피', event='단가변경', cost='8', comment='해동피:8 -> 8:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:00';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:51:02'  WHERE herb='해백';
insert into herbhistory set herb='해백', event='단가변경', cost='20', comment='해백:20 -> 20:전사분기  없어서 그 이전사분기(2023-1) 검색하여 단가책정', write_time='2024-08-30 16:51:02';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:51:03' WHERE herb='해표초';
insert into herbhistory set herb='해표초', event='단가변경', cost='18', comment='해표초:18 -> 18:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:03';
UPDATE herb SET cost = 12, cost_date='2024-08-30 16:51:03' WHERE herb='행인';
insert into herbhistory set herb='행인', event='단가변경', cost='12', comment='행인:12 -> 12:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:03';
UPDATE herb SET cost = 16, cost_date='2024-08-30 16:51:04' WHERE herb='향부자';
insert into herbhistory set herb='향부자', event='단가변경', cost='16', comment='향부자:16 -> 16:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:04';
UPDATE herb SET cost = 15, cost_date='2024-08-30 16:51:08'  WHERE herb='향유';
insert into herbhistory set herb='향유', event='단가변경', cost='15', comment='향유:15 -> 15:전사분기  없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:51:08';
UPDATE herb SET cost = 26, cost_date='2024-08-30 16:51:08' WHERE herb='현삼';
insert into herbhistory set herb='현삼', event='단가변경', cost='26', comment='현삼:26 -> 26:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:08';
UPDATE herb SET cost = 14, cost_date='2024-08-30 16:51:11'  WHERE herb='현초';
insert into herbhistory set herb='현초', event='단가변경', cost='14', comment='현초:14 -> 14:전사분기  없어서 그 이전사분기(2021-4) 검색하여 단가책정', write_time='2024-08-30 16:51:11';
UPDATE herb SET cost = 57, cost_date='2024-08-30 16:51:12' WHERE herb='현호색';
insert into herbhistory set herb='현호색', event='단가변경', cost='57', comment='현호색:57 -> 57:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:12';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:51:13' WHERE herb='형개';
insert into herbhistory set herb='형개', event='단가변경', cost='20', comment='형개:20 -> 20:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:13';
UPDATE herb SET cost = 46, cost_date='2024-08-30 16:51:16' WHERE herb='홍화';
insert into herbhistory set herb='홍화', event='단가변경', cost='46', comment='홍화:46 -> 46:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:16';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:51:17' WHERE herb='화피';
insert into herbhistory set herb='화피', event='단가변경', cost='8', comment='화피:8 -> 8:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:17';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:51:21'  WHERE herb='활석';
insert into herbhistory set herb='활석', event='단가변경', cost='8', comment='활석:8 -> 8:전사분기  없어서 그 이전사분기(2024-1) 검색하여 단가책정', write_time='2024-08-30 16:51:21';
UPDATE herb SET cost = 20, cost_date='2024-08-30 16:51:22' WHERE herb='황금2';
insert into herbhistory set herb='황금2', event='단가변경', cost='20', comment='황금2:20 -> 20:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:22';
UPDATE herb SET cost = 25, cost_date='2024-08-30 16:51:23' WHERE herb='황금고';
insert into herbhistory set herb='황금고', event='단가변경', cost='25', comment='황금고:25 -> 25:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:23';
UPDATE herb SET cost = 27, cost_date='2024-08-30 16:51:23' WHERE herb='황금주초';
insert into herbhistory set herb='황금주초', event='단가변경', cost='27', comment='황금주초:27 -> 27:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:23';
UPDATE herb SET cost = 16, cost_date='2024-08-30 16:51:24' WHERE herb='황금초';
insert into herbhistory set herb='황금초', event='단가변경', cost='16', comment='황금초:16 -> 16:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:24';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:51:25' WHERE herb='황기';
insert into herbhistory set herb='황기', event='단가변경', cost='18', comment='황기:18 -> 18:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:25';
UPDATE herb SET cost = 33, cost_date='2024-08-30 16:51:25' WHERE herb='황기밀구';
insert into herbhistory set herb='황기밀구', event='단가변경', cost='33', comment='황기밀구:33 -> 33:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:25';
UPDATE herb SET cost = 133, cost_date='2024-08-30 16:51:26' WHERE herb='황련';
insert into herbhistory set herb='황련', event='단가변경', cost='133', comment='황련:130 -> 133:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:26';
UPDATE herb SET cost = 159, cost_date='2024-08-30 16:51:27' WHERE herb='황련주초';
insert into herbhistory set herb='황련주초', event='단가변경', cost='159', comment='황련주초:153 -> 159:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:27';
UPDATE herb SET cost = 18, cost_date='2024-08-30 16:51:28' WHERE herb='황백';
insert into herbhistory set herb='황백', event='단가변경', cost='18', comment='황백:18 -> 18:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:28';
UPDATE herb SET cost = 32, cost_date='2024-08-30 16:51:29'  WHERE herb='황백염초';
insert into herbhistory set herb='황백염초', event='단가변경', cost='32', comment='황백염초:32 -> 32:전사분기  없어서 그 이전사분기(2023-3) 검색하여 단가책정', write_time='2024-08-30 16:51:29';
UPDATE herb SET cost = 28, cost_date='2024-08-30 16:51:30' WHERE herb='황백주초';
insert into herbhistory set herb='황백주초', event='단가변경', cost='28', comment='황백주초:28 -> 28:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:30';
UPDATE herb SET cost = 23, cost_date='2024-08-30 16:51:31' WHERE herb='황정';
insert into herbhistory set herb='황정', event='단가변경', cost='23', comment='황정:23 -> 23:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:31';
UPDATE herb SET cost = 11, cost_date='2024-08-30 16:51:31' WHERE herb='후박';
insert into herbhistory set herb='후박', event='단가변경', cost='11', comment='후박:11 -> 11:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:31';
UPDATE herb SET cost = 24, cost_date='2024-08-30 16:51:32' WHERE herb='흑두';
insert into herbhistory set herb='흑두', event='단가변경', cost='24', comment='흑두:24 -> 24:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:32';
UPDATE herb SET cost = 8, cost_date='2024-08-30 16:51:36' WHERE herb='흑축';
insert into herbhistory set herb='흑축', event='단가변경', cost='8', comment='흑축:8 -> 8:전사분기(2024-2) 고려  단가변경', write_time='2024-08-30 16:51:36';
UPDATE herb SET cost = 39, cost_date='2024-08-30 16:51:39'  WHERE herb='희첨';
insert into herbhistory set herb='희첨', event='단가변경', cost='39', comment='희첨:39 -> 39:전사분기  없어서 그 이전사분기(2022-2) 검색하여 단가책정', write_time='2024-08-30 16:51:39';