Affinity Rat SQL

[xMoOment]

Hat jemand den Code für Navicat um die Affinity Rate zu erhöhen ?

[GenYanny]

UPDATE t_affinity_work SET a_value = a_value *1 WHERE a_work_type = 1;

grüßle

[NominAtiVGenItIv]

UPDATE t_affinity_work SET a_value = a_value * 2 WHERE a_work_type = 0; (ITEM AFFINITY RATE)
UPDATE t_affinity_work SET a_value = a_value * 2 WHERE a_work_type = 1; (MOB AFFINITY RATE)