I've ran into a little roadblock while creating a WHILE loop within a procedure that's intended to go through every row within a table, world.creature_template.

Query runs fine in my database, no warnings or errors, but it's not actually changing anything at all. Affected rows are always at 0.

Link to the code is below, thanks in advance.

Some sample records:

entry	difficulty_entry_1	difficulty_entry_2	difficulty_entry_3	KillCredit1	KillCredit2	modelid1	modelid2	modelid3	modelid4	name	subname	IconName	gossip_menu_id	minlevel	maxlevel	exp	faction	npcflag	speed_walk	speed_run	scale	rank	dmgschool	BaseAttackTime	RangeAttackTime	BaseVariance	RangeVariance	unit_class	unit_flags	unit_flags2	dynamicflags	family	type	type_flags	lootid	pickpocketloot	skinloot	PetSpellDataId	VehicleId	mingold	maxgold	AIName	MovementType	HoverHeight	HealthModifier	ManaModifier	ArmorModifier	DamageModifier	ExperienceModifier	RacialLeader	movementId	RegenHealth	mechanic_immune_mask	spell_school_immune_mask	flags_extra	ScriptName	VerifiedBuild
29	0	0	0	25499	0	25275	0	0	0	Kanrethad	Master of Death		0	90	90	0	35	0	1	1.14286	1	0	0	2000	2000	1	1	1	0	2048	0	0	7	0	0	0	0	0	0	0	0		0	1	1250	1	1	1	1	0	0	1	0	0	0		12340
30	0	0	0	0	0	382	0	0	0	Forest Spider			0	5	6	0	22	0	1	0.85714	1	0	0	2000	2000	1	1	1	0	2048	0	3	1	1	30	0	0	5880	0	0	0	SmartAI	1	1	1	1	1	1	1	0	100	1	0	0	0		12340
31	0	0	0	0	0	145	0	0	0	Furbolg			0	1	2	0	35	0	1.2	1.14286	1	0	0	2000	2000	1	1	1	0	2048	0	0	0	0	0	0	0	0	0	0	0		0	1	1	1	1	1	1	0	0	1	0	0	0		12340
36	0	0	0	0	0	367	0	0	0	Harvest Golem			0	11	12	0	14	0	1	1.14286	1	0	0	2000	2000	1	1	1	0	2048	0	0	9	32768	36	0	0	0	0	13	21		1	1	1	1	1	1	1	0	0	1	16384	0	0		12340
38	0	0	0	0	0	5035	5036	0	0	Defias Thug			0	3	4	0	7	0	1	0.85714	1	0	0	2000	2000	1	1	1	0	2048	0	0	7	0	38	38	0	0	0	2	7	SmartAI	1	1	1	1	1	1	1	0	100	1	0	0	0		12340
40	0	0	0	0	0	373	0	0	0	Kobold Miner			0	6	7	0	26	0	1	0.85714	1	0	0	2000	2000	1	1	1	0	2048	0	0	7	0	40	40	0	0	0	5	12	SmartAI	1	1	1	1	1	1	1	0	100	1	0	0	0		12340

generated 2024-03-31 22:08:23 by HeidiSQL 12.1.0.6537