Sign in Get Started

mysql trigger example

A-312 
-- The following statement creates an AFTER UPDATE trigger on the sales table:

DELIMITER $$

CREATE TRIGGER after_sales_update
AFTER UPDATE
ON sales FOR EACH ROW
BEGIN
    IF OLD.quantity <> new.quantity THEN
        INSERT INTO SalesChanges(salesId,beforeQuantity, afterQuantity)
        VALUES(old.id, old.quantity, new.quantity);
    END IF;
END$$

DELIMITER ;
View another examples Add Own solution
Log in, to leave a comment

0
0
Awgiedawgie 440215 points 

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

0
0
4
2
Awgiedawgie 440215 points 

                                    CREATE
    TRIGGER `event_name` BEFORE/AFTER INSERT/UPDATE/DELETE
    ON `database`.`table`
    FOR EACH ROW BEGIN
		-- trigger body
		-- this code is applied to every 
		-- inserted/updated/deleted row
    END;
    
CREATE
	TRIGGER `blog_after_insert` AFTER INSERT 
	ON `blog` 
	FOR EACH ROW BEGIN
	
		IF NEW.deleted THEN
			SET @changetype = 'DELETE';
		ELSE
			SET @changetype = 'NEW';
		END IF;
    
		INSERT INTO audit (blog_id, changetype) VALUES (NEW.id, @changetype);
		
    END$$

4 (2 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
mysql database triggers trigger on mysql triggers examples in mysql how to see the triggers in mysql mysql trigger tasks how to call trigger in mysql how to make a trigger mysql does mysql have triggers mysql triggers events mysql query triggers implementing trigger in mysql simple trigger example in mysql sql trigger example mysql mysql create trigger command line add trigger to mysql trigger tutorial mysql create a trigger in mysql trigger sql mysql mysql triggers definition triggers mysql$ uses [of mYSQL triggers call trigger in mysql how create trigger in mysql example trigger mysql how mysql trigger works mysql triggers after triggers mysql add trigger mysql query trigger create mysql trigger how to make trigger in mysql use of when in trigger in mysql triggers on database in mysql syntaxe trigger mysql when do trigger occur in mysql TRIGGERS ON MYSQL mysql select triggers trigger with function mysql mysql call trigger mysql run trigger manually mysql triggers if with and mysql triggers if mysql trigger with time mssql trigger to mysql example mysql trigger new mysql trigger new create trigger on insert mysql trigger in my sql what is definer in mysql trigger how to use trigger in mysql triggersin mysql what is trigger in mysql with examples mysql create trigger sample where in trigger mysql how to create trigger in mysql code mysql and or trigger mysql use function in trigger mysql triggers\ mysql trigger example for experienced trigger new mysql create trigger mysql example program to create trigger mysql triggers in mysql example mysql database by triggers create trigger on mysql command line trigger en mysql mysql triggers ? mysql triggers / how to add triggers in mysql trigger example mysql types of triggers in mysql call trigger in a trigger mysql mysql statement trigger MYSQL TRIGGERES trigger in the mysql tutorial mysql triggers trigger statement level mysql creste triggers in mysql mysql trigger syntax how to add trigger in mysql what are triggers in mysql mySQL trigger tutorial create triggerin mysql when do we use trigger in mysql mysql trigger definition mysql triggers tutorial what is the use of triggers in mysql when can we use trigger in mysql what is use of trigger in mysql list of triggers command in mysql list of triggers in mysql syntax to create trigger in mysql how to create a trigger in mysql mysql function in trigger declare on triggers in mysql what is trigger mysql is mysql trigger a function triggers in mysql examples mysql creating trigger mysql trigger example create a trigger in mysql query MYSQL trigger examples mysql how to create trigger triggers syntax in mysql how to write trigger in mysql sql trigger mysql mysql what is a trigger trigger use in mysql trigger in database mysql trigger syntax mysql display triggers in mysql mysql what are triggers used for triggers in mysql with example mysql triggers examples how to create a trigger in mysql workbench postgres trigger what is a trigger mysql creaate trigger mysql how to create trigger after update in mysql how to create a trigger mysql allow insert with trigger but not manual in mysql event in trigger in mysql type of trigger and its example in mysql create trigger inside trigger mysql create trigger in trigger mysql what is trigger in mysql write trigger in mysql select statement to use in in triggers mysql trigger mysql sample triggers in mysql wher to store mysql trigger trigger mysql database how to create trigger in mysql with example can we write normal query in mysql trigger how to create database trigger in mysql trigger supported in mysql trigger syntax in mysql SQL trigger in mysql how to make triggers in mysql mysql trigger types mysql workbench create trigger mysql trtigger trigger output models in mysql ,mysql trigger only on new record trigger for mysql for each row in mysql trigger mysql trigger stored mysql create or replace trigger select trigger mysql BEGIN END TRIGGER SQL A statement-level trigger mysql python mysql trigger definer create trigger mysql value below 0 create triggr action mysql using software mysql basic trigger create trigger sum mysql mysql create trigger syntax mysql 8 create trigger into archive table triggers in my SQL mysql workbench trigger before update trigger sql example how can i add trigger fn in my sql project how to create trigger mysql how to attach multiple triggers to a db in mysql workbench what does trigger doesnot exist in mysql workbench mean how to create and run trigger in mysql how and where to create trigger in mysql how to create trigger in mysql trigger mysql example mysql trigger which MySQL command line tool returns trigger list can a new Myswl table have atrigge where do i see triggers mysql create trigger mysql create trigger in mysql how to write a trigger in mysql what is triggers in mysql create trigger in mysql example where to execute triggers in mysql trigger example in mysql mysql trigger error in SET statement mysql trigger options make trigger in mysql using a trigger in mysql mysql trigger what how to make triggers on mysql mysql trigger mysql how to use created trigger in mysql trigger in mysql syntax for trigger in mysql trigger in mysql example database triggers mysql mysql trigger set table tirgger in mysql add trigger in mysql MYSQL trigger OR syntax for create trigger in mysql new mysql triggers mysql example trigger create mysql trigger example mysql create table no trigger create triggers mysql create trigger mysql cmd how to create trigger in mysql workbench mysql triggers valid events mysql trigger or condition creating triggers in mysql triggers that trigger on trigger of mysql triggers in mysql how to create trigger in mysql phpmyadmin that prints when a condition is met create trigger syntax in mysql mysql sample trigger update table trigger in mysql create triggers in mysql trigger format in mysql how to write triggers in mysql how to write a trigger for mysql mysql trigger with example mysql triggers example mysql triggers trigger examples mysql triggers mysql mysql event trigger types how to create triggers in mysql how to run trigger in mysql mysql use trigger trigger in mysql syntax trigger mysql syntax create a trigger using phpmyadmin creating triggers in phpmyadmin creating a trigger mysql writing a trigger in mysql mysql create trigger
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source