N/APosted on - 07/08/2014
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?
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
CREATE TRIGGER tr_insert_employee
if (select province from inserted) <> 'BC'
PRINT 'record will not update if province is not BC'