Hi,
I could envision a way of doing this when accessing your tables
only via Stored Procedures instead of using them directly.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Hi listers
I have a mysql web application. in this application it would be fine to be
able to track the database entries i have visited, because often later on
i grat my head: which entry did i see this already in?
So i would need a way to find out which entries in which table i have
visited lately.
i first created a last_access table column and updated it before selecting
the table entry, but alas, this way i also updated the last_update entry
of the table which has "on update current_timestamp". it can't be done
this way.
i also looked for an "on select" event in mysql, but i was not sucessful.
also, the "show status" command was not helpful.
the complicated way would be to create a special table and make entries
into it whenever i access entries in different tables.
when googling around i found, it is even not easy to find out, which
tables have been accessed in general. if, now, i want to know even which
row in a particular table has been accessed at which time, the problem
gets even more difficult.
does anybody have a solution to this, which is easier than the complicated
way mentionned earlier?
thanks for any hints.
suomi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org