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

/home/kozerus/public_html/ko_center/sql

-- defrag_upd_kohw.sql

	update kohw set ip='ip' where ip == '';
	update kohw set ips='ips' where ips == '';
	update kohw set sn='sn' where sn == '';
	update kohw set hrctag='hrctag' where hrctag == '';
	update kohw set bluetag='bluetag' where bluetag == '';
	update kohw set hostname='hostname' where hostname == '';
	update kohw set os='os' where os == '';
	update kohw set osver='osver' where osver == '';


	update koplans set ip = (select ip from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set os = (select os from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set sn = (select sn from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set osver = (select osver from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set hrctag = (select hrctag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set bluetag = (select bluetag from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );
	update koplans set hostname = (select hostname from kohw where koplans.cab==kohw.cab and koplans.item==kohw.item );