product_stocks_update.sql

-- Insert some new records.
INSERT INTO data.product_stocks
  (category, stock, check_time)
VALUES
  ('Laptops', 1313, '2022-01-02 18:00:00'),
  ('Tablets', 867, '2022-01-02 18:00:00'),
  ('Cellphones', 5000, '2022-01-02 18:00:00')
ON DUPLICATE KEY UPDATE
  stock = VALUES(stock)
;

-- Check records with stock greater than 0.
SELECT * FROM data.product_stocks
WHERE stock > 0
;