how to make trigger in phpmyadmin

 delimiter // 
 CREATE TRIGGER removeforeing 
  BEFORE DELETE ON products
  FOR EACH ROW BEGIN
    DELETE FROM sales_details WHERE product_code = OLD.product_code;
 END// 
 delimiter ;

View another examples Add Own solution

3.5

Phoenix Logan 186120 points

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

Thank you! 2

3.5 (2 Votes)

Awgiedawgie 440220 points

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

Thank you! 1

5 (1 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

add trigger in phpmyadmin php my admin trigger mysql trigger phpmyadmin phpmyadmin create trigger how to create a trigger in phpmyadmin phpmyadmin php trigger phpmyadmin trigger trigger mysql phpmyadmin phpmyadmin triggers the trigger trigger phpmyadmin create trigger phpmyadmin what is trigger in phpmyadmin trigger in phpmyadmin triggers phpmyadmin mysql phpmyadmin trigger command how to make a backup from mysql workbench for phpmyadmin how to make trigger in phpmyadmin Create Trigger in phpMyAdmin

how to make trigger in phpmyadmin

Welcome Back!

Create a Free Account