DIR : /home/kozerus/public_html/ko_center/sql/ko_center.sql

/home/kozerus/public_html/ko_center/sql

defrag_fromcabs.sql:-- defrag_fromcabs.sql
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs.sql:--	from kohw
defrag_fromcabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs.sql:--	order by cab, amps desc;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:	select 'defrag_fromcabs', date('now'), planid, cab, item, amps, hostname, sn, hrctag, bluetag, ip from koplans
defrag_fromcabs.sql:	order by planid, cab;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs.sql:--	from kohw
defrag_fromcabs.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_fromcabs.sql:--	order by cab, amps desc;
defrag_fromcabs.sql:
defrag_fromcabs.sql:
defrag_fromcabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs_sum.sql:-- defrag_fromcabs_sum.sql
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs_sum.sql:--	from kohw
defrag_fromcabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_fromcabs_sum.sql:--	order by cab, amps desc;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
defrag_fromcabs_sum.sql:	group by planid, cab
defrag_fromcabs_sum.sql:	order by planid, cab;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_fromcabs_sum.sql:--	from kohw
defrag_fromcabs_sum.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_fromcabs_sum.sql:--	order by cab, amps desc;
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:
defrag_fromcabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_items.sql:-- defrag_fromcabs.sql
defrag_items.sql:
defrag_items.sql:	select cab,item,hostname,sn,hrctag,bluetag,ip from kohw
defrag_items.sql:	where cab in ( select cab from koplans where planid == 'plan1' );
defrag_plans_items_amps.sql:-- defrag_plans_items_amps
defrag_plans_items_amps.sql:
defrag_plans_items_amps.sql:	select 'defrag_plans_items_amps', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_amps.sql:	group by planid, cab, cab2, item
defrag_plans_items_amps.sql:	order by planid, amps desc, cab, cab2;
defrag_plans_items_cab.sql:-- defrag_plans_items_cab
defrag_plans_items_cab.sql:
defrag_plans_items_cab.sql:	select 'defrag_plans_items_cab', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_cab.sql:	group by planid, cab, cab2, item
defrag_plans_items_cab.sql:	order by planid, cab, cab2, amps desc;
defrag_plans_items.sql:-- defrag_plans_items
defrag_plans_items.sql:
defrag_plans_items.sql:	select 'defrag_plans_items', date('now'), planid, item, cab, cab2, sum(amps) amps from koplans
defrag_plans_items.sql:	group by planid, cab, cab2, item
defrag_plans_items.sql:	order by planid, item, cab, cab2, amps desc;
defrag_plans_items_sumamps.sql:-- defrag_plans_items_sumamps
defrag_plans_items_sumamps.sql:
defrag_plans_items_sumamps.sql:	select 'defrag_plans_items_sumamps', date('now'), planid, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_sumamps.sql:	group by planid, cab, cab2
defrag_plans_items_sumamps.sql:	order by planid, amps desc, cab, cab2;
defrag_plans_items_sum.sql:-- defrag_plans_items_sum
defrag_plans_items_sum.sql:
defrag_plans_items_sum.sql:	select 'defrag_plans_items_sum', date('now'), planid, cab, cab2, sum(amps) amps from koplans
defrag_plans_items_sum.sql:	group by planid, cab, cab2
defrag_plans_items_sum.sql:	order by planid, cab, cab2;
defrag_plans.sql:-- defrag_plans
defrag_plans.sql:
defrag_plans.sql:	select 'defrag_plans', date('now'), cab,cab2,item,amps,sn,hostname,hrctag,ip from koplans;
defrag_plans_sumcab.sql:-- defrag_plans_items_sum
defrag_plans_sumcab.sql:
defrag_plans_sumcab.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
defrag_plans_sumcab.sql:--	from koplans
defrag_plans_sumcab.sql:--	where loadmode == ''
defrag_plans_sumcab.sql:--	group by planid, cabnum, cablim
defrag_plans_sumcab.sql:--	order by planid, cabnum, cablim
defrag_plans_sumcab.sql:--	;
defrag_plans_sumcab.sql:
defrag_plans_sumcab.sql:
defrag_plans_sumcab.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
defrag_plans_sumcab.sql:	from koplans
defrag_plans_sumcab.sql:	where loadmode==''
defrag_plans_sumcab.sql:	group by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sumcab.sql:	order by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sumcab.sql:	;
defrag_plans_sum.sql:-- defrag_plans_items_sum
defrag_plans_sum.sql:
defrag_plans_sum.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
defrag_plans_sum.sql:	from koplans
defrag_plans_sum.sql:	where loadmode == ''
defrag_plans_sum.sql:	group by planid, cabnum, cablim
defrag_plans_sum.sql:	order by planid, cabnum, cablim
defrag_plans_sum.sql:	;
defrag_plans_sum.sql:
defrag_plans_sum.sql:
defrag_plans_sum.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
defrag_plans_sum.sql:--	from koplans
defrag_plans_sum.sql:--	where loadmode==''
defrag_plans_sum.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sum.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
defrag_plans_sum.sql:--	;
defrag_sel_kohw_amps.sql:-- defrag_sel_kohw_amps.sql
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:
defrag_sel_kohw_amps.sql:--	select 'defrag_sel_kohw_amps', date('now'), planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_kohw_amps.sql:	select 'defrag_sel_kohw_amps', date('now'), item, cab, amps from kohw where amps != ''
defrag_sel_kohw_amps.sql:	order by item, cab;
defrag_sel_kohw_nullamps.sql:-- defrag_sel_nullamp
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:
defrag_sel_kohw_nullamps.sql:--	select planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_kohw_nullamps.sql:	select 'defrag_del_nullamp', date('now'), cab, item, amps from kohw where amps == '';
defrag_sel_koplans_nullamps.sql:-- defrag_sel_koplans_nullamp
defrag_sel_koplans_nullamps.sql:
defrag_sel_koplans_nullamps.sql:
defrag_sel_koplans_nullamps.sql:	select 'defrag_sel_koplans_nullamp', date('now'), planid, cab, cab2, item, amps from koplans where amps == '';
defrag_sel_koplans_nullamps.sql:
defrag_sel_nullamps.sql:-- defrag_sel_nullamp
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:
defrag_sel_nullamps.sql:	select 'defrag_sel_nullamp', date('now'), cab, item, amps from kohw where amps == '';
defrag_tocabs.sql:-- defrag_tocabs.sql
defrag_tocabs.sql:
defrag_tocabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs.sql:--	from kohw
defrag_tocabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs.sql:--	order by cab, amps desc;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:	select 'defrag_tocabs', date('now'), planid, cab2, item, amps, hostname, sn, hrctag, bluetag, ip from koplans
defrag_tocabs.sql:	order by planid, cab2;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs.sql:--	from kohw
defrag_tocabs.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_tocabs.sql:--	order by cab, amps desc;
defrag_tocabs.sql:
defrag_tocabs.sql:
defrag_tocabs.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs_sum.sql:-- defrag_tocabs_sum.sql
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs_sum.sql:--	from kohw
defrag_tocabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_tocabs_sum.sql:--	order by cab, amps desc;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:	select 'defrag_tocabs_sum', date('now'), planid, cab2, sum(amps) from koplans 
defrag_tocabs_sum.sql:	group by planid, cab2
defrag_tocabs_sum.sql:	order by planid, cab2;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
defrag_tocabs_sum.sql:--	from kohw
defrag_tocabs_sum.sql:--	where cab in ( select distinct( cab ) from koplans )
defrag_tocabs_sum.sql:--	order by cab, amps desc;
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:
defrag_tocabs_sum.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
defrag_upd_kohw.sql:-- defrag_upd_kohw.sql
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:	update kohw set ip='ip' where ip == '';
defrag_upd_kohw.sql:	update kohw set ips='ips' where ips == '';
defrag_upd_kohw.sql:	update kohw set sn='sn' where sn == '';
defrag_upd_kohw.sql:	update kohw set hrctag='hrctag' where hrctag == '';
defrag_upd_kohw.sql:	update kohw set bluetag='bluetag' where bluetag == '';
defrag_upd_kohw.sql:	update kohw set hostname='hostname' where hostname == '';
defrag_upd_kohw.sql:	update kohw set os='os' where os == '';
defrag_upd_kohw.sql:	update kohw set osver='osver' where osver == '';
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:
defrag_upd_kohw.sql:	update koplans set ip = (select ip from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set os = (select os from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set sn = (select sn from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set osver = (select osver from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set hrctag = (select hrctag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set bluetag = (select bluetag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
defrag_upd_kohw.sql:	update koplans set hostname = (select hostname from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
jk1.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk1.sql:
jk1.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1.sql:--	from kohw
jk1.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk1.sql:--	order by cab, amps desc;
jk1.sql:
jk1.sql:
jk1.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk1.sql:	group by planid, cab
jk1.sql:	order by planid, cab;
jk1.sql:
jk1.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk1.sql:--	from kohw
jk1.sql:--	where cab in ( select distinct( cab ) from koplans )
jk1.sql:--	order by cab, amps desc;
jk1.sql:
jk1.sql:
jk1.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk2.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk2.sql:
jk2.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk2.sql:--	from kohw
jk2.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk2.sql:--	order by cab, amps desc;
jk2.sql:
jk2.sql:
jk2.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk2.sql:	group by planid, cab
jk2.sql:	order by planid, cab;
jk2.sql:
jk2.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk2.sql:--	from kohw
jk2.sql:--	where cab in ( select distinct( cab ) from koplans )
jk2.sql:--	order by cab, amps desc;
jk2.sql:
jk2.sql:
jk2.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk3.sql:
jk3.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3.sql:--	from kohw
jk3.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk3.sql:--	order by cab, amps desc;
jk3.sql:
jk3.sql:
jk3.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk3.sql:	group by planid, cab
jk3.sql:	order by planid, cab;
jk3.sql:
jk3.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk3.sql:--	from kohw
jk3.sql:--	where cab in ( select distinct( cab ) from koplans )
jk3.sql:--	order by cab, amps desc;
jk3.sql:
jk3.sql:
jk3.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk4.sql:
jk4.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4.sql:--	from kohw
jk4.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk4.sql:--	order by cab, amps desc;
jk4.sql:
jk4.sql:
jk4.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk4.sql:	group by planid, cab
jk4.sql:	order by planid, cab;
jk4.sql:
jk4.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk4.sql:--	from kohw
jk4.sql:--	where cab in ( select distinct( cab ) from koplans )
jk4.sql:--	order by cab, amps desc;
jk4.sql:
jk4.sql:
jk4.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk5.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk5.sql:
jk5.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk5.sql:--	from kohw
jk5.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk5.sql:--	order by cab, amps desc;
jk5.sql:
jk5.sql:
jk5.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk5.sql:	group by planid, cab
jk5.sql:	order by planid, cab;
jk5.sql:
jk5.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk5.sql:--	from kohw
jk5.sql:--	where cab in ( select distinct( cab ) from koplans )
jk5.sql:--	order by cab, amps desc;
jk5.sql:
jk5.sql:
jk5.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk.sql:-- jk.sql from defrag_fromcabs_sum.sql
jk.sql:
jk.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk.sql:--	from kohw
jk.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
jk.sql:--	order by cab, amps desc;
jk.sql:
jk.sql:
jk.sql:	select 'defrag_fromcabs_sum', date('now'), planid, cab, sum(amps) from koplans 
jk.sql:	group by planid, cab
jk.sql:	order by planid, cab;
jk.sql:
jk.sql:--	select cab, item, amps, hostname, sn, hrctag, bluetag, ip 
jk.sql:--	from kohw
jk.sql:--	where cab in ( select distinct( cab ) from koplans )
jk.sql:--	order by cab, amps desc;
jk.sql:
jk.sql:
jk.sql:--	where cab in ( select cab from koplans where planid == 'plan1' )
sm1.sql:-- defrag_plans_items_sum
sm1.sql:
sm1.sql:	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, sum(amps) samps 
sm1.sql:	from koplans
sm1.sql:	where loadmode == ''
sm1.sql:	group by planid, cabnum, cablim
sm1.sql:	order by planid, cabnum, cablim
sm1.sql:	;
sm1.sql:
sm1.sql:
sm1.sql:--	select 'defrag_plans_items_sum', date('now'), planid, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm1.sql:--	from koplans
sm1.sql:--	where loadmode==''
sm1.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm1.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
sm1.sql:--	;
sm2.sql:-- defrag_plans_items_sum
sm2.sql:
sm2.sql:--	select 'defrag_plans_sum', date('now'), planid, loadmode, cabnum,cablim, sum(amps) samps 
sm2.sql:--	from koplans
sm2.sql:--	where loadmode == ''
sm2.sql:--	group by planid, cabnum, cablim
sm2.sql:--	order by planid, cabnum, cablim
sm2.sql:--	;
sm2.sql:
sm2.sql:
sm2.sql:	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm2.sql:	from koplans
sm2.sql:	where loadmode==''
sm2.sql:	group by planid, cabnum, cablim, cab, cab1, cab2
sm2.sql:	order by planid, cabnum, cablim, cab, cab1, cab2
sm2.sql:	;
sm3.sql:-- defrag_plans_items_sum
sm3.sql:
sm3.sql:--	select 'defrag_plans_sum', date('now'), planid, loadmode, cabnum,cablim, sum(amps) samps 
sm3.sql:--	from koplans
sm3.sql:--	where loadmode == ''
sm3.sql:--	group by planid, cabnum, cablim
sm3.sql:--	order by planid, cabnum, cablim
sm3.sql:--	;
sm3.sql:
sm3.sql:
sm3.sql:--	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, sum(amps) samps 
sm3.sql:--	from koplans
sm3.sql:--	where loadmode==''
sm3.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:--	order by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:--	;
sm3.sql:
sm3.sql:	select 'defrag_plans_sumcab', date('now'), planid, loadmode, cabnum,cablim, cab,cab1,cab2, amps, hostname, sn, hrctag, ip 
sm3.sql:	from koplans
sm3.sql:	where loadmode==''
sm3.sql:--	group by planid, cabnum, cablim, cab, cab1, cab2
sm3.sql:	order by planid, cabnum, cablim, cab, cab1, cab2, amps, hostname, sn, hrctag, ip
sm3.sql:	;
sm4.sql:-- sm4.sql
sm4.sql:-- ======
sm4.sql:
sm4.sql:--	20121128_1215 jk	
sm4.sql:
sm4.sql:	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
sm4.sql:	from koplans
sm4.sql:	where loadmode == ''
sm4.sql:	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
sm4.sql:	order by planid, loadmode, cabnum,cablim, samps, cab, cab1, cab2
sm4.sql:	;
sm4.sql:	
sm5.sql:-- sm5.sql
sm5.sql:-- ======
sm5.sql:
sm5.sql:--	20121128_1215 jk	
sm5.sql:
sm5.sql:	select planid, loadmode, cabnum, cablim, sum(amps) samps
sm5.sql:	from koplans
sm5.sql:	where loadmode != ''
sm5.sql:	group by planid, loadmode, cabnum, cablim
sm5.sql:	order by planid, loadmode, cabnum, cablim, samps 
sm5.sql:	;
sm5.sql:	
sm.sql:-- sm.sql
sm.sql:-- ======
sm.sql:
sm.sql:--	20121128_1215 jk	
sm.sql:
sm.sql:	select planid, loadmode, cabnum, cablim, cab,cab1,cab2, sum(amps) samps
sm.sql:	from koplans
sm.sql:	where loadmode != ''
sm.sql:	group by planid, loadmode, cabnum,cablim, cab, cab1, cab2 
sm.sql:	order by planid, loadmode, cabnum,cablim, cab, cab1, cab2
sm.sql:	;
sm.sql:	
wk1.sql:-- wk.sql
wk1.sql:
wk1.sql:	select *
wk1.sql:	from kohw limit 10
wk1.sql:	
wk2.sql:-- wk.sql
wk2.sql:
wk2.sql:	select *
wk2.sql:	from kohw limit 10
wk2.sql:	
wk3.sql:-- wk.sql
wk3.sql:
wk3.sql:	select *
wk3.sql:	from kohw limit 10
wk3.sql:	
wk4.sql:-- wk.sql
wk4.sql:
wk4.sql:	select *
wk4.sql:	from kohw limit 10
wk4.sql:	
wk5.sql:-- wk.sql
wk5.sql:
wk5.sql:	select *
wk5.sql:	from kohw limit 10
wk5.sql:	
wk.sql:-- wk.sql
wk.sql:
wk.sql:	select *
wk.sql:	from kohw limit 10
wk.sql: