MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

Create a trigger that prevents updating all rows in a table
Posted by: david lee
Date: August 29, 2017 12:08PM

I'm new to triggers, and still a new web developer.

I have an "Emails" table and there is a bug that sets the 'sent_at' column to today's date for all the rows (and there are over a million rows)
This happens every few months or so and it's a pain in the ass to fix.

Is there a trigger I can write that will prevent my "Emails" table from updating all the rows? It can be done in SQL server, but I haven't found anything in mysql.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Create a trigger that prevents updating all rows in a table
1277
david lee
August 29, 2017 12:08PM
Re: Create a trigger that prevents updating all rows in a table
665
Peter Brawley
August 29, 2017 01:08PM
Re: Create a trigger that prevents updating all rows in a table
906
david lee
August 29, 2017 01:57PM
Re: Create a trigger that prevents updating all rows in a table
640
Peter Brawley
August 29, 2017 02:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.