phpmyadmin create trigger code example

Example 1: Create Trigger in phpMyAdmin

CREATE TRIGGER `before_delete` BEFORE DELETE ON `barcode_master` 
FOR EACH ROW BEGIN 
UPDATE library_emp_master SET job_type = 1 WHERE barcode_no =   OLD.barcode_no; 
END;

Example 2: Create Trigger in phpMyAdmin

DELIMITER &&
 
CREATE OR REPLACE TRIGGER tr_ajoutHotelResponsable
BEFORE INSERT ON cpoa.hotels
FOR EACH ROW
BEGIN
    IF(
        EXISTS(
            SELECT *
            FROM cpao.responsables
            WHERE numResponsable = NEW.numResponsable
        )
    )
    THEN
        UPDATE cpoa.responsables
        SET nbHotel = nbHotel + 1
        WHERE numResponsable = NEW.numResponsable;
    ELSE
        INSERT INTO cpao.responsables ( nom, prenom, nbHotels )
        VALUES ( 'nouveau', 'nouveau', 1 );
         
        SET NEW.numResponsable = LAST_INSERT_ID();
    END IF;
END&&
 
DELIMITER ;