update row of one table with row inserted in other table SQLITE
-
wrote on 21 Dec 2017, 07:35 last edited by
Hello,
I have 2 tables sqlite and on each I have common name column "registration".
when I insert in the first table the drive time of the day, I have to increase the total time in the second table.
Could you help me?
thank you for your help -
Hello,
I have 2 tables sqlite and on each I have common name column "registration".
when I insert in the first table the drive time of the day, I have to increase the total time in the second table.
Could you help me?
thank you for your help@filipdns It is not really a Qt question more a SQL question.
In SQL you can use triggers for that. See http://www.mysqltutorial.org/create-the-first-trigger-in-mysql.aspx
https://sqlite.org/lang_createtrigger.html
2/2