I am new to MySQL and learning about trigger. I have 2 tables that I want : when a table (detail_transaction) has been inserted, a 'stock' field of another table (item) change. 'item' Table id name price stock 1 Item_A…
(obs: the ids are not pk they are unique keys, the pks are a government "id" called cpf); I want to create a function that reads the id in table1 [person] of a person and then insert this [person].id in…
I am creating a sports database and am trying to add a trigger to my DDL. The aim of the trigger is to insert values into a table (commitment) whenever another table (player) has a college commitment (col_commit) change from…
I need to have modifed_at fields in my Django project. A field that updates every time a row updates in the database, despite where the update comes from: through calling .save() or through queryset.update() or even when updates happen in…
I have created some schemas (dsfv, dsfn, etc.) and insert some tables inside each schema, including the following tables : poste_hta_bt (parent table with attribute "code_pt" as unique key); transfo_hta_bt (having also "code_pt" attribute as foreign key that referenced poste_hta_bt).…
I have a scenario, where a trigger function is activated before an update of some sort. And in order for the condition to be met one of the columns must be excluded from the "OLD" and "NEW" objects. CREATE FUNCTION…
I'm new to trigger functions and PostgreSQL, and I'm trying create a calculated field combining other fields (I know that this might violate the normal forms, but I'm working with a pre-existing naming convention). The goal is to have the…
CREATE TABLE wishlist( year YEAR NOT NULL, ssn CHAR(14), delivered BIT, PRIMARY KEY (year, ssn), FOREIGN KEY (ssn) REFERENCES child (child_ssn) ) engine=innodb; CREATE TABLE wishlistDelivered( year YEAR NOT NULL, ssn CHAR(14), delivered BIT, PRIMARY KEY (year, ssn), FOREIGN KEY…
I have a postgres table in the form of id x_loc 1000 12.7 1500 13.2 1001 12.7 1502 13.2 1002 12.8 and want to make a rule or trigger that will update the x_loc column for all rows that meet…
I'm using PostgreSQL with Rails in API mode and I have a row called expired with data type Date and I want to make a trigger that identifies if the expired date is equal to the current date and change…