triggger mysql 5 multiple INSERT

trigger-mysql-multiple.sql

USE asistemas;

DROP TRIGGER IF EXISTS MiTrigger;

DELIMITER |
CREATE TRIGGER MiTrigger AFTER INSERT ON asistemas.users
   FOR EACH ROW
   BEGIN

	INSERT INTO asistemas.oauth_users (username, password, first_name, last_name) 
		VALUES (NEW.email_user, NEW.password_user, NEW.username_user, 'A');

	INSERT INTO asistemas.searchs (id_user, name) 
    VALUES (NEW.id_user, NEW.username_user);
    
    
    
    

-- trigger with parameter
CREATE DEFINER = CURRENT_USER TRIGGER `asistemas`.`users_AFTER_UPDATE` AFTER UPDATE ON `users` FOR EACH ROW
   BEGIN
   -- PARAMETER
   DECLARE type_user VARCHAR(10);
   SELECT type_user INTO type_user
	FROM users WHERE id_user = NEW.id_user ;

   
   BEGIN
    -- FIRST SENTENCE
    UPDATE oauth_users
		SET password= NEW.password_user
		WHERE username=NEW.email_user;
    
	-- SECOND SENTENCE
      IF (NEW.type_user <> '' AND NEW.type_user = 'DOC') THEN
    	UPDATE searchs
			SET username_user = NEW.username_user
			WHERE id_user = NEW.id_user;
      END IF;
            
   END;
END



   END |

DELIMITER ;


-- 03 variables
DECLARE total_products INT DEFAULT 0;
SELECT COUNT(*) INTO total_products FROM products;
-- 
DECLARE vapenid INT;
SET vapenid = (SELECT vapen FROM Alien_Använder_Vapen WHERE idAlien = OLD.idAlien);