CREATE TABLE products(
productId INT(10) NOT NULL AUTO_INCREMENT, 
productName VARCHAR(10),
PRIMARY KEY (productId));
 
CREATE TABLE stocks(
stock INT(10), 
productId INT(10),
FOREIGN KEY (productId) REFERENCES products(productId));

 
CREATE TRIGGER update_detail BEFORE UPDATE ON product
FOR EACH ROW
 
SET @id = SELECT id FROM product;
SET @remain = SELECT amount FROM product;
 
INSERT INTO detail (id,remain) VALUES (@id ,@remain );
 

 
CREATE TRIGGER update_detail 
BEFORE UPDATE ON product
FOR EACH ROW
 
     IF OLD.amount<NEW.amount THEN
         SET NEW.girdi = NEW.amount - OLD.amount ;
     ELSEIF OLD.amount>NEW.amount THEN
         SET NEW.cikti = OLD.amount - NEW.amount ;
     END IF;
 
INSERT INTO DETAIL 
(id, oldAmount, newAmount, girdi, cikti, kalan) 
VALUES 
(OLD.id, OLD.amount, NEW.amount, NEW.girdi, NEW.cikti, NEW.amount);