delete from commodity_mst;
insert into commodity_mst select * from (

select 1 as commodity_no,'REGZA 58M500X [58インチ]' as commodity_name,137383 as unit_price,10 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 2 as commodity_no,'AQUOS LC-60US40 [60インチ]' as commodity_name,183500 as unit_price,50 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 3 as commodity_no,'ブルーレイディーガ DMR-BRW1010' as commodity_name,43702 as unit_price,0 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 4 as commodity_no,'BDZ-ZW1000' as commodity_name,39408 as unit_price,90 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 5 as commodity_no,'NW-A35 [16GB]' as commodity_name,19098 as unit_price,100 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 6 as commodity_no,'REGZA 32S5[32C`]' as commodity_name,29900 as unit_price,120 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 7 as commodity_no,'BDZ-EW500' as commodity_name,37400 as unit_price,5 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 8 as commodity_no,'BRAVIA KDL-55HX850[55C`]' as commodity_name,143900 as unit_price,200 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 9 as commodity_no,'HD-LBF20TU2' as commodity_name,8800 as unit_price,50 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 10 as commodity_no,'DriveStation HD-LB2OTU2/N' as commodity_name,8980 as unit_price,80 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 11 as commodity_no,'WD Elements fXNgbv WDBAAU0020HBK' as commodity_name,7708 as unit_price,20 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 12 as commodity_no,'LHD-EN2000U2W' as commodity_name,11980 as unit_price,60 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 13 as commodity_no,'HDPC-UT1.0S[Vo[×O[]' as commodity_name,8343 as unit_price,70 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 14 as commodity_no,'HD-PV500U2-BK/N' as commodity_name,5480 as unit_price,90 as stock,now() as insert_at,now() as update_at,null as delete_at Union
select 15 as commodity_no,'H6510BD' as commodity_name,92780 as unit_price,100 as stock,now() as insert_at,now() as update_at,null as delete_at

) Q_1;



delete from consumer_mst;
INSERT INTO consumer_mst Select * From (

Select 1 As consumer_no,'井田 和義' As consumer_name,'イダ カズヨシ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 2 As consumer_no,'齋藤 綾子' As consumer_name,'サイトウ アヤコ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 3 As consumer_no,'山田 太郎' As consumer_name,'ヤマダ タロウ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 4 As consumer_no,'高橋 秀樹' As consumer_name,'タハカシ ヒデキ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 5 As consumer_no,'山本 太郎' As consumer_name,'ヤマモト タロウ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 6 As consumer_no,'品川 正二' As consumer_name,'シナガワ ショウジ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 7 As consumer_no,'高木 義男' As consumer_name,'タカギ ヨシオ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 8 As consumer_no,'新法 みどり' As consumer_name,'シンポウ ミドリ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 9 As consumer_no,'山本 高之' As consumer_name,'ヤマモト タカユキ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 10 As consumer_no,'山田 肇' As consumer_name,'ヤマダ ハジメ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 11 As consumer_no,'新田 俊' As consumer_name,'ニッタ シュン' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 12 As consumer_no,'飯田 香' As consumer_name,'イイダ カオリ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 13 As consumer_no,'山下 達郎' As consumer_name,'ヤマシタ タツロウ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 14 As consumer_no,'新谷 順' As consumer_name,'シンタニ ジュン' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 15 As consumer_no,'山下 義則' As consumer_name,'ヤマシタ ヨシノリ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 16 As consumer_no,'新山 千春' As consumer_name,'ニイヤマ チハル' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 17 As consumer_no,'斉藤 英明' As consumer_name,'サイトウ ヒデアキ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 18 As consumer_no,'飯島 辰則' As consumer_name,'イイジマ タツノリ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 19 As consumer_no,'谷原 正二' As consumer_name,'タニハラ ショウジ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 20 As consumer_no,'福山 正春' As consumer_name,'フクヤマ マサハル' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 21 As consumer_no,'福田 高之' As consumer_name,'フクダ タカユキ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 22 As consumer_no,'中曽根 登' As consumer_name,'ナカソネ ノボル' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 23 As consumer_no,'田中 武彦' As consumer_name,'タナカ タケヒコ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 24 As consumer_no,'山本 山' As consumer_name,'ヤマモト ヤマ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 25 As consumer_no,'飯山 一' As consumer_name,'イイヤマ ハジメ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 26 As consumer_no,'栗橋 啓太' As consumer_name,'クリハシ ケイタ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 27 As consumer_no,'栗林 順太' As consumer_name,'クリバヤシ ジュンタ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 28 As consumer_no,'堀田 剛' As consumer_name,'' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 29 As consumer_no,'寺山 卓' As consumer_name,'テラヤマ スグル' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at Union
Select 30 As consumer_no,'本田 宗一郎' As consumer_name,'ホンダ ソウイチロウ' As consumer_kana,now() as insert_at,now() as update_at,null as delete_at

) Q_1;


DELETE FROM details_tbl;
INSERT INTO details_tbl Select * From (

Select 1 As details_no,1 As consumer_no,now() as insert_at,now() as update_at,null as delete_at Union
Select 2 As details_no,2 As consumer_no,now() as insert_at,now() as update_at,null as delete_at Union
Select 3 As details_no,1 As consumer_no,now() as insert_at,now() as update_at,null as delete_at Union
Select 4 As details_no,3 As consumer_no,now() as insert_at,now() as update_at,null as delete_at

) Q_1;


DELETE FROM details_sub_tbl;
INSERT INTO details_sub_tbl Select * From (

Select 1 As details_no,1 As commodity_no,137383 As unit_price,2 As quantity,274766 As total_price,now() as insert_at,now() as update_at,null as delete_at Union
Select 1 As details_no,2 As commodity_no,183500 As unit_price,10 As quantity,1835000 As total_price,now() as insert_at,now() as update_at,null as delete_at Union
Select 2 As details_no,2 As commodity_no,183500 As unit_price,5 As quantity,917500 As total_price,now() as insert_at,now() as update_at,null as delete_at Union
Select 3 As details_no,1 As commodity_no,137383 As unit_price,10 As quantity,1373830 As total_price,now() as insert_at,now() as update_at,null as delete_at Union
Select 3 As details_no,3 As commodity_no,43702 As unit_price,10 As quantity,437020 As total_price,now() as insert_at,now() as update_at,null as delete_at Union
Select 4 As details_no,3 As commodity_no,43702 As unit_price,5 As quantity,218510 As total_price,now() as insert_at,now() as update_at,null as delete_at 

) Q_1;