MySQL trigger On Insert/Update events

by

With Grijesh’s perfect help and his suggestion to use conditional statements, I was able to get ONE trigger that does both tasks. Thanks again Grijesh 

 DELIMITER $$ 
 CREATE TRIGGER update_count AFTER INSERT ON ext_words 
 FOR EACH ROW 
   BEGIN
     IF NOT EXISTS (SELECT 1 FROM ext_words_count WHERE word = NEW.word) THEN
       INSERT INTO ext_words_count (word) VALUES (NEW.word);
   ELSE
       UPDATE ext_words_count SET word_count = word_count + 1 WHERE word = NEW.word;
   END IF;
  END $$    
 DELIMITER;

More Related Contents:

  1. MySQL trigger to update a field to the value of id
  2. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  3. Insert into a MySQL table or update if exists
  4. How to set initial value and auto increment in MySQL?
  5. How to do a batch insert in MySQL
  6. MySql Error: Can’t update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
  7. LAST_INSERT_ID() MySQL
  8. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  9. Increment a database field by 1
  10. How to program a MySQL trigger to insert row into another table?
  11. TRIGGERs that cause INSERTs to fail? Possible?
  12. Use a trigger to stop an insert or update
  13. Importing a CSV to MySQL with different date format
  14. How can I set a maximum number of rows in MySQL table?
  15. Update a column in MySQL
  16. Field ‘id’ doesn’t have a default value?
  17. MySQL INSERT INTO … VALUES and SELECT
  18. MySQL error 1241: Operand should contain 1 column(s)
  19. insert data from one table to another in mysql
  20. Reserved word in column name – insert into MySQL [duplicate]
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. Mysql insert into 2 tables
  23. Can I launch a trigger on select statement in mysql?
  24. Insert data into table with result from another select query
  25. MySQL: Insert datetime into other datetime field
  26. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  27. Incorrect integer value: ” for column ‘id’ at row 1
  28. MySQL listen notify equivalent
  29. Calling an url from a trigger in mysql
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment