Useful SQL commands in MariaDB

donataz · May 20

Just finished setting up my own server and ran into some SQL commands that were very helpful. Improvise and change what you need how you need it and want it.
Most of them are pretty self explanatory but I'l do my best to explain

UPDATE buff_templates
SET itemid = 57;

Updates table buff_templates and sets in each itemid to ADENA. Using same logic other tables and rows can be updated, inserted changed.

INSERT INTO `droplist` VALUES ('22105', '8085', '8', '15', '8', '1000000');

I used this to insert into specific raidboss a drop in this case (premium coin). values can be edited.

UPDATE `buff_templates` 
SET `useitem`='0' 
WHERE `itemId`='6393';

In this example we replace certain values where they can be found. If we have any itemID 6393 the sql swapped useitem to 0 which means not to use item. Its easy to edit this to change different stuff around without having to do it manualy by one. setting where condition only replaces it where it finds it and does not touche other rows.

UPDATE `droplist` SET `chance`='7500' 
WHERE `itemId`='6393' 
AND chance='15000';

This is the one I use more frequently when I want to chance lets say drop chance for 1 item, but the item has been inserted into many RB's. We set the Where condition to find the item, we set the new chance , and the last row AND chance only finds where the item has this specific chance to drop. I have inserted the same item into other raidboses with different chance and did not want to change that.
I will update more as I go on.