How to make trigger in phpmyadmin

Create Trigger in phpMyAdmin

DROP TRIGGER IF EXISTS testTrigger;
CREATE TRIGGER testTrigger 
BEFORE INSERT ON tbl_table1 
FOR EACH ROW 
BEGIN 
  INSERT INTO tbl_table2 VALUES (NEW.id,NEW.name);
END;

Source: stackoverflow.com

How to make trigger in phpmyadmin

ALTER TABLE sales_details
ADD FOREIGN KEY fk_product_code(product_code)
REFERENCES products(product_code)
ON DELETE CASCADE;

Source: dba.stackexchange.com

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;

Source: stackoverflow.com

Create Trigger in phpMyAdmin

CREATE TRIGGER before_insert_money BEFORE INSERT ON money
FOR EACH ROW UPDATE accounts SET balance=10.0;

Source: stackoverflow.com

Create Trigger in phpMyAdmin

delimiter //
CREATE TRIGGER before_insert_money BEFORE INSERT ON money
FOR EACH
ROW
BEGIN
    UPDATE accounts SET balance=10.0;
END;
//
delimiter ;

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote216 views1 answer
Sql sum show 0 result
SQL
0 vote225 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
13 votes200 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote204 views1 answer
Change database name psql 8
SQL
2 votes210 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote227 views1 answer
Reindex mssql table
SQL
0 vote187 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote194 views1 answer
List column names of multiple tables psql
SQL
6 votes272 views2 answers
Mysql check auto increment value
SQL