I decided to add a check to the code for loading data from the table - “should it be updated?”. Collected the following "bicycle":

QSqlQuery query; query.exec("show table status from "+base); while(query.next() && query.value(0).toString()!=table) {} if (query.value(12).toString() != updatecheck || query.value(12).toString()=="") { // ... и пошла загрузка

With this method, the request to display information on all tables is not particularly encouraging, plus on some servers, update_time simply not fixed and the field is always empty.

What other methods exist to solve this problem?

Method by id last update: if you update two times the same record that already exists, then there will be no download?

It is possible on a predetermined trigger, but this means that it should be, plus, triggers slow down the work of the database as a whole. This is true?

  • And if you had postgres, everything would be different. - gbg

0