TRUNCATE TABLE stocks;
LOAD DATA LOCAL INFILE "/tmp/stocks.csv" INTO TABLE stocks FIELDS TERMINATED BY ',' ENCLOSED BY '"';
UPDATE stocks SET available_quantity = existing_quantity WHERE warehouse_id!=660 AND warehouse_id!=706 AND available_quantity=0;
UPDATE stocks SET customer_id=NULL where warehouse_id=660 OR warehouse_id=706;
UPDATE stocks SET validity_period=60 where product_id=384 OR product_id=385;
DELETE from stocks where customer_id=NULL AND warehouse_id!=660 AND warehouse_id!=706 AND existing_quantity=0