mysql_update.sql

	update 
		test_k a 
		left outer join(
			select parent, floor(avg(progress)) as avg
				from test_k 
					group by parent
		) b on a.id = b.parent
	set 
		a.progress = b.avg
	where 
		avg is not null;