Breaking News: Grepper is joining You.com. Read the official announcement!

Mysql create trigger

Add Answer

Singh99 answered on October 14, 2020 Popularity 9/10 Helpfulness 1/10

answer Mysql create trigger

related trigger in mysql syntax

related mysql trigger

related mysql Trigger

Mysql create trigger

Comment

CREATE DEFINER=`root`@`localhost` TRIGGER increment_animal
  AFTER INSERT ON animals FOR EACH ROW
    UPDATE animal_count SET animal_count.animals = animal_count.animals+1;
ERROR 1359 (HY000): Trigger already exists

CREATE OR REPLACE DEFINER=`root`@`localhost` TRIGGER increment_animal
  AFTER INSERT ON animals  FOR EACH ROW
    UPDATE animal_count SET animal_count.animals = animal_count.animals+1;
Query OK, 0 rows affected (0.12 sec)

CREATE DEFINER=`root`@`localhost` TRIGGER IF NOT EXISTS increment_animal
  AFTER INSERT ON animals FOR EACH ROW
    UPDATE animal_count SET animal_count.animals = animal_count.animals+1;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql [localhost] {msandbox} (test) > SHOW WARNINGS;
+-------+------+------------------------+
| Level | Code | Message                |
+-------+------+------------------------+
| Note  | 1359 | Trigger already exists |
+-------+------+------------------------+
1 row in set (0.00 sec)

Popularity 9/10 Helpfulness 1/10 Language sql

Source: mariadb.com

Tags: mysql sql

Link to this answer
Share Copy Link

Contributed on Apr 04 2022

Singh99

0 Answers Avg Quality 2/10

Closely Related Answers

trigger in mysql syntax

Comment

CREATE TRIGGER trigger_name
{BEFORE | AFTER} {INSERT | UPDATE| DELETE }
ON table_name FOR EACH ROW
trigger_body;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.mysqltutorial.org

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 14 2020

Ramis

0 Answers Avg Quality 2/10

mysql trigger

Comment

CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
  a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  b4 INT DEFAULT 0
);

delimiter //
CREATE TRIGGER name_of_trigger [BEFORE|AFTER] [INSERT|UPDATE|DELETE] 
ON test1
FOR EACH ROW
BEGIN
	/* 
    Examples of code to write 
    */
	[INSERT|DELETE|UPDATE|IF|ELSEIF|END IF];
    /* 
    NEW.a1 meanse the new value that will be added with INSERT into test1
    */
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
    IF NEW.a1 < 0 THEN
    	SET NEW.a1 = 0;
    ELSEIF NEW.a1 > 100 THEN
    	SET NEW.a1 = 100;
    END IF;
END//
delimiter;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: dev.mysql.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Jun 02 2022

Hou

0 Answers Avg Quality 2/10

mysql Trigger

Comment

select trigger_schema, trigger_name, action_statement
from information_schema.triggers

Popularity 9/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Sep 29 2022

Curious Crayfish

0 Answers Avg Quality 2/10

Mysql create trigger

Contents

More Related Answers

Mysql create trigger

Closely Related Answers

trigger in mysql syntax

mysql trigger

mysql Trigger

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.