mysql after insert trigger which updates another table’s column

by

Try this:

DELIMITER $$
CREATE TRIGGER occupy_trig
AFTER INSERT ON `OccupiedRoom` FOR EACH ROW
begin
       DECLARE id_exists Boolean;
       -- Check BookingRequest table
       SELECT 1
       INTO @id_exists
       FROM BookingRequest
       WHERE BookingRequest.idRequest= NEW.idRequest;

       IF @id_exists = 1
       THEN
           UPDATE BookingRequest
           SET status="1"
           WHERE idRequest = NEW.idRequest;
        END IF;
END;
$$
DELIMITER ;

More Related Contents:

  1. MySQL: How do I use delimiters in triggers?
  2. MySQL – UPDATE query based on SELECT Query
  3. MySQL, update multiple tables with one query
  4. Throw an error preventing a table update in a MySQL trigger
  5. How to abort INSERT operation in MySql trigger?
  6. mysql update column with value from another table
  7. MySQL Trigger after update only if row has changed
  8. MySQL error code: 1175 during UPDATE in MySQL Workbench
  9. update multiple rows using limit in mysql?
  10. How to program a MySQL trigger to insert row into another table?
  11. TRIGGERs that cause INSERTs to fail? Possible?
  12. MySQL update a joined table
  13. MySQL Fire Trigger for both Insert and Update
  14. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  15. MySQL error 1436: Thread stack overrun, with simple query
  16. MySQL trigger to update a field to the value of id
  17. mysql trigger stored trigger is already used by statement which invoked stored trigger
  18. My MySQL trigger doesn’t work, simple syntax, not complicated
  19. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  20. Advanced MySql Query: Update table with info from another table
  21. What are differences between INSERT and UPDATE in MySQL?
  22. MySQL Trigger: Delete From Table AFTER DELETE
  23. Does MySQL overwrite a column of same value on update?
  24. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  25. mySQL UPDATE query returns “0 rows affected”
  26. Using MySQL triggers to log all table changes to a secondary table
  27. How to create and insert a JSON object using MySQL queries?
  28. The best way to remove value from SET field?
  29. Update MySQL with if condition
  30. MySQL disable all triggers

Leave a Comment