How to make Trigger in MySQL?

Asked By abrahamahartman 60 points N/A Posted on - 07/08/2014

Hi Everyone,

I am using MySQL 3.51 for a online store.

There are many repeated customers in the site.

So, I want to maintain a database of the repeated customers.

How can I implement a Trigger for those customer account for two fields?

Please help with an example.

Can anyone give me some videos?

Thanks.

 

• Status: Open
• Question Views: 708
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Marende Leen 0 points N/A #141495

How to make Trigger in MySQL?

Triggers are very useful for your program here is the simplest format how you can create triggers in sql

//INSERT Trigger

CREATE TRIGGER tr_insert_employee

ON Employees

for insert

as

if (select province from inserted) <> 'BC'

BEGIN

PRINT 'record will not update if province is not BC'

ROLLBACK TRANSACTION

END 

About Marende Leen

Questions
3

Answers
62

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/09/2014
• Question Category: MySQL Server