Is there a way to know how many a table have been consulted in mysql?

Question

I m developping an application about store management and the dev team wants me to add an update a read counter for every table. For the update I managed to do this, but I want to know if there is a proper solution (standardized) to update a value of a column when a row is selected.

Like for multilanguage we have the i18n, is there any standards for this, or should I after every select launch an update on the read counting column for the selected id(s)?

Answer 1

the best way that we found is to make the select statement s in a stored procedures where we update the reading field counter