Affinity Rat SQL

12/12/2014 03:34 xMoOment#1
Hat jemand den Code für Navicat um die Affinity Rate zu erhöhen ?
12/12/2014 03:51 GenYanny#2
UPDATE t_affinity_work SET a_value = a_value *1 WHERE a_work_type = 1;

grüßle :)
12/12/2014 05:43 NominAtiVGenItIv#3
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)