SQL request problem

Custom Code and Mods Custom Code and Requests
1

I want to apply that command on every single entry

UPDATE item_template SET dmg_min1 = dmg_min1 / delay WHERE entry = 809;//works, his dmg_min1 / his delay

UPDATE item_template SET dmg_min1 = dmg_min1 / delay WHERE entry > 0; //sql error

I cant do each entry 1 by 1

need help !

2

what is the sql error you get? Division by 0?
You might want to exclude all rows that have delay set to 0

WHERE delay <> 0

3

i solved it by : update item_template set dmg_min1 = dmg_min1 / delay where delay > 0 and entry > 0 order by entry;