Fork me on GitHub
SQL Question
Post: #1
Hi

After getting values from SELECT how do I format the output in a certain way?

Code:
SELECT entry,
    HealthMultiplier,
    PowerMultiplier,
    DamageMultiplier,
    DamageVariance,
    ArmorMultiplier,
    ExperienceMultiplier
FROM creature_template
WHERE entry BETWEEN 1 AND 29095;

I want about 30k rows to format this way:
Code:
UPDATE creature_template SET HealthMuliplier = "VALUE", PowerMultiplier = "VALUE", etc etc.. WHERE entry = 123;

Help is much appreciated!
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
  Question about Factions and Flags. stavaren 2 319 04-09-2017, 01:25 PM
Last Post: stavaren
  [ALL] Question about forum rules. alysher 4 482 03-17-2017, 01:25 PM
Last Post: alysher
  Question about the database DaMadBot 5 1,200 08-01-2016, 05:22 PM
Last Post: DaMadBot
  [WOTLK] Question about expansions. DaMadBot 1 716 05-12-2016, 07:31 PM
Last Post: evil@wow
  [CLASSIC] Question about the SEND_GOSSIP_MENU method marshmillo 0 1,156 02-24-2015, 09:57 AM
Last Post: marshmillo
  [CLASSIC] The question of playerbot. arh1038 1 3,261 09-01-2014, 02:26 PM
Last Post: cala
  [WOTLK] Dungeon/Raid scripts & Question about custom scripts Blindguard 25 20,663 07-26-2014, 02:27 AM
Last Post: Castro
  [CLASSIC] Single Player Dungeon question cydher 9 11,824 06-12-2014, 01:23 PM
Last Post: cala
  Sql question pinzu 2 2,234 05-19-2014, 09:34 AM
Last Post: pinzu
  [CLASSIC] English / German Question ThunderScript 1 2,018 09-26-2013, 06:38 PM
Last Post: Schmoozerd

Forum Jump:


Users browsing this thread: 1 Guest(s)

Continued MaNGOS | Return to Top | | Lite (Archive) Mode | RSS Syndication