Column Editing

[Desufire]

Okay I've been adding numbers to theroam column in mob_group sql for over an hour. I've barely made a dent. There's gotta be a way to edit an entire column at once. I have sublime, visual, and notepad++. Who's my hero?

[Delaide]

Notepad ++ ctrl+h?

[kjLotus]

use an sql query?

[Desufire]

Yeah, we figured out how to write an update query.

Got another question though. How can I import a custom sql? Like, I have a custom item_mod sql that I usually just execute after item_mod, but I'd like to be able to add it so that it shows in Navicat and has its tables shown.

[demolish]

sql file is just a bunch of queries
since your queries have

Code: Select all

UPDATE `item_mods`

it'll run the queries on the item_mods table (since that's the table you're making changes to)

easiest way would be to write a separate SELECT query for your custom items and save it in navicat e.g.
SELECT * FROM item_mods WHERE itemid IN(itemid, anotheritemid, etc)

[Desufire]

sql file is just a bunch of queries
since your queries have

Code: Select all

UPDATE `item_mods`

it'll run the queries on the item_mods table (since that's the table you're making changes to)

easiest way would be to write a separate SELECT query for your custom items and save it in navicat e.g.
SELECT * FROM item_mods WHERE itemid IN(itemid, anotheritemid, etc)

Okay. Always learning something new lol. Thanks all.