Get Date/Time of Changes made to a database or specfic table

Hi,

I wanted to know how I can access the inforamtion, when a table was created, the last change was made to it.

And if it is possible, I'd alos would like to know, if there is a way to get the time when a data row was last manipulated (inserted, updated). Or do I have to build my own solution in the application?

I'm using MySQL with the Database ruuning the InnoDB Engine.

Thanks

Oliver

[429 byte] By [eversora] at [2007-11-27 6:17:18]
# 1

After some more research it seems that MySQL doesn't offer some buikt-in functions for my needs (and for that matterJDBC also doesn't offer API access to that functions)

I resort to my own solution. Here are some nice finds into the subject:

http://www.mysql.com/certification/mysql-certification-41addendum.pdf

http://www.futhark.ch/mysql/108.html

eversora at 2007-7-12 17:30:05 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...