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

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 copy_pid AFTER INSERT on upload FOR EACH ROW 

BEGIN

INSERT INTO rating (uid,pid) VALUES (NEW.username,NEW.id);

END$$
delimiter ;

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

Create Trigger in phpMyAdmin

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

Source: stackoverflow.com

Create Trigger in phpMyAdmin

CREATE TRIGGER after_update
       AFTER UPDATE ON hodm
       FOR EACH ROW 

       INSERT INTO hodm_log
       SET log_action = 'update',
        user_name = NEW.user_name,
           log_timestamp = NOW();

Source: stackoverrun.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 TABLE contacts
( contact_id INT(11) NOT NULL AUTO_INCREMENT,
  last_name VARCHAR(30) NOT NULL,
  first_name VARCHAR(25),
  birthday DATE,
  CONSTRAINT contacts_pk PRIMARY KEY (contact_id)
);

-1

Source: techonthenet.com

Similar codes

0 vote125 views1 answer
Fetching data from mysqldb
SQL
0 vote121 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote197 views1 answer
Mysql show schema
SQL
32 votes123 views6 answers
How to change column name in sql
SQL
1 vote118 views1 answer
Sql upsert
SQL
1 vote156 views4 answers
How to check table in postgresql from terminal
SQL
3 votes117 views2 answers
Truncate all tables
SQL
0 vote139 views1 answer
Mysql case when on date
SQL
0 vote117 views1 answer
Get first monday of month sql
SQL
1 vote116 views1 answer
Oracle repeat_interval 5 minutes
SQL