We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [database-trigger]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
39 views

update trigger insert only if value is different

i have some gps modules that send data to my database. On update of the last package sent i want to compare new values with old values and insert into a new table only those values that are diferent. ...
2
votes
1answer
47 views

Trigger working on more than 50 million records [closed]

I have a table with more than 50,000,000 records. The table doesn't have any partition. The table is in PROD. I need to create a trigger there which will update previous entries flag to false for ...
0
votes
1answer
17 views

MySQL Syntax error when trying to create database trigger

When Trying to create the below trigger, I am receiving a syntax error. It looks good to me and I'm having a terrible time trying to figure it out. DELIMITER $$ CREATE TRIGGER trg_pic_hours ...
0
votes
1answer
21 views

Trigger on PostGIS line layer occurs twice

Using this tutorial, I've established a SQL trigger in order to track changes on a PostGIS layer. It works great for a point layer. However, using the script below, it causes problems with line layer, ...