July 28, 2006

MySQL Data Dictionary

Found the MySQL data dictionary in a database called information_schema. There is a table there named Tables. Using the fields TABLE_NAME and UPDATE_TIME you can select the most recent changes to the database.

This could be used as part of the caching expiration mechanism of Syndibase.

Posted in Software |
3 Comments »

2 Comments 1 Trackback

3 Responses to “MySQL Data Dictionary”

santosh, on October 21st, 2009 at 4:51 am Said:

Great thanks

You’re welcome. Funny how such notes prove useful to others.

Leave a Reply