Questions tagged as 'trigger'

Tagged questions
0
answers

Trigger does not work

I do not have much practice in MySQL and I need to create a trigger to update a column of a table when a new record is inserted, but when you insert a new row, nothing happens. I've already changed everything I could and I could not make the tri...
asked by 12.07.2017 / 15:08
1
answer

Update Trigger in Mysql

I do not know much about Mysql and I need to do a trigger to update a line right after insertion. When the user registers an order he selects how many orders he wants. In the database a type is saved in one column and in another column the amoun...
asked by 29.06.2017 / 20:24
0
answers

Problem with trigger change

I have a table that receives data all the time, almost every second. This table has a trigger that after insertion of a new row inserts this record into another table. I need to include a new trigger in the same table and I have some question...
asked by 05.06.2017 / 16:47
0
answers

Firebase Database - Event-based notifications

I have a project that needs to send notifications when certain data is added to the Firebase. I did several web searches, but I could not find a way that would work to implement this notification. I saw in the Firebird documentation that yo...
asked by 19.04.2017 / 21:29
1
answer

Executing a system command with a parameter inside a Function in PostgreSQL

I'm having a hard time creating a function in Postgres running a shell Linux command, with one detail: function Trigger after insert and I need to use some columns of NEW . In Mysql , using plugin...
asked by 03.04.2017 / 22:58
1
answer

Delete duplicate rows with postgresql conditionals

My code takes information from the internet and inserts it into the database, however, it inserts the same information more than once a day. I need to leave only 1 record information per day, that is, each day the program runs, it will only i...
asked by 14.03.2017 / 13:16
1
answer

How to make modification records in a MySQL table (without using triggers)?

I would like to know if there is another technique of making record changes in the tables without going through triggers ?     
asked by 21.12.2016 / 11:46
0
answers

how to solve this trigger in MySQL?

create trigger tr_kmanterior before insert on t_consumos for each row set new.kmanterior_c = (preview.kmatual_c); OR create trigger tr_kmanterior before insert on t_consumos for each row set new.kmanterior_c = (old.kmatual_c); I need to p...
asked by 26.08.2016 / 03:58
0
answers

Mysql Trigger with more than one cursor

I have a Trigger where I have 3 cursors, but it only correctly executes one of them (soma_pontuacao_cursor), the other two are executed in the wrong way, I already tried with three separate loops, and it also did not work. My perception says tha...
asked by 03.08.2016 / 10:52
1
answer

Calculating items sales order jquery

I have a problem that I can not solve. I have a sales order screen where it has to do the quantity calculation X unit value = (fill in the total value and add up to the total of the order), how do I To do this calculation with jquery someone can...
asked by 31.05.2016 / 20:19