[Calisthenics]

Quote:

Originally Posted by GospodinX It's great.Is there anything for example that amount can't be 0?(if it's 0 delete row).I just need it now.

The only thing similar to this is triggers: https://dev.mysql.com/doc/refman/8.0...er-syntax.html
I never used them with INSERT .. ON DUPLICATE so I am not sure. An example:

pawn Код:

CREATE TRIGGER remove_item BEFORE INSERT ON inventory
  FOR EACH ROW
    DELETE FROM inventory WHERE amount = 0;

However, I find this method way not appropriate. You do know the amount of item before executing query so you can delete when it is 0 and insert/update when it is not.