discuss

Download

discuss@lists.mariadb.org

April 2024

19 participants
11 discussions

Help - Creating a loop to go through every row in a table, no errors, not working
by ram3n 02 Apr '24

02 Apr '24

Hi all, 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. https://srcb.in/YVuGJQU4o8 Some sample records: entrydifficulty_entry_1difficulty_entry_2difficulty_entry_3KillCredit1 KillCredit2modelid1modelid2modelid3modelid4namesubnameIconNamegossip_menu_id minlevelmaxlevelexpfactionnpcflagspeed_walkspeed_runscalerankdmgschool BaseAttackTimeRangeAttackTimeBaseVarianceRangeVarianceunit_classunit_flags unit_flags2dynamicflagsfamilytypetype_flagslootidpickpocketlootskinloot PetSpellDataIdVehicleIdmingoldmaxgoldAINameMovementTypeHoverHeight HealthModifierManaModifierArmorModifierDamageModifierExperienceModifier RacialLeadermovementIdRegenHealthmechanic_immune_mask spell_school_immune_maskflags_extraScriptNameVerifiedBuild 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 <https://www.heidisql.com/>*

1 0