update row of one table with row inserted in other table SQLITE
Unsolved
General and Desktop
-
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
