Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement.
Let’s see an example of Create Trigger:
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:
- To prevent invalid transactions
- Security authorizations impose
- Like auditing
- Referential integrity enforce
- Event logging
- Information store on table access
- Synchronous replication of tables
- Generate derived column values automatically

Namaste UI collaborates closely with clients to develop tailored guest posting strategies that align with their unique goals and target audiences. Their commitment to delivering high-quality, niche-specific content ensures that each guest post not only meets but exceeds the expectations of both clients and the hosting platforms. Connect with us on social media for the latest updates on guest posting trends, outreach strategies, and digital marketing tips. For any types of guest posting services, contact us on info[at]namasteui.com.