Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement.
For example we have two tables i.e. users and userhistory.
users:
userID
firstName
lastName
userhistory:
userID
last_update
Read Also: INSERT … ON DUPLICATE KEY UPDATE
Now we will create a trigger before update users table:
DELIMITER $$ CREATE TRIGGER before_user_update BEFORE UPDATE ON users FOR EACH ROW BEGIN INSERT INTO userhistory SET last_update = NOW(), userID = OLD.userID; END$$ DELIMITER ;
Whenever user update their information userhistory table also get updated automatically.
Triggers could be defined on the table, schema, view or database with which the event is associated.
Triggers can be written for the following purposes:
For any types of queries, you can contact us on info[at]namasteui.com.
We've gotten so used to seeing men streetwear joggers, ripped jeans, and sleeveless shirts. Hair…
When it comes to festivals, the options for wedding jewellery are endless. You can go…
Whether it concerns your home or an office building, the state of a property’s windows…
You know that running an environmentally sustainable business is the right thing to do. But…
If you are in a financial crisis , or need to start a new business…
To realize the strategic advantage from the fleet management system (FMS) and differentiate the business…