[Tool] SQL Insert Into to Update Convertor -
06-03-2008
I made this for 2d, but I'll post it for you all. This little utility takes a .txt file with INSERT INTO commands and converts them all to UPDATE commands. Example:
Code:
INSERT INTO creature_names VALUES (1337,4,4,-1)
becomes
Code:
UPDATE creature_names SET entry = 1338 WHERE entry = 1337
The entry number (in that example, 1338) is set by the user for each entry, so if you're doing a big list you'll be typing in a LOT of numbers.
Things to note:
-The thing breaks if a line doesn't follow the syntax in the first code box. Comments are a no-no.
-You need to press Load before Convert.
-You need the full path of each file, drive and all. If the output file exists....I don't know what will happen XD
Changelog:
v1.0 - Initial release
Virus Scan: [Only registered and activated users can see links. ]
Download: [Only registered and activated users can see links. ]
Last edited by ReidE96; 06-04-2008 at 04:26 PM.
Reason: Forgot a virus scan. My bad.