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 vote110 views1 answer
Create synonym for dblink in oracle
SQL
0 vote110 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
2 votes111 views1 answer
Dbms transaction (psql)
SQL
0 vote112 views1 answer
Cast float mysql
SQL
0 vote114 views1 answer
Oracle sql number to varchar2
SQL
2 votes162 views1 answer
Postgresql group by month and year
SQL
5 votes101 views3 answers
How to remove unique key constraint in mysql
SQL
15 votes106 views4 answers
Export mysql db using command line
SQL
5 votes124 views1 answer
Oracle asynchronous query
SQL
0 vote110 views1 answer
How to use sqlcommand
SQL