<div>
SELECT max(last_user_update) last_user_update<br />
FROM sys.dm_db_index_usage_stat<wbr />s<br />
WHERE database_id = DB_ID( 'YOUR_DBNAME_HERE')<br />
<br />
or<br />
<br />
This Blog entry contains information on how to do it on SQL Server 2008 and 2005.<br />
<a href="http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx" rel="ugc">http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx</a>
</div>


SELECT max(last_user_update) last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'YOUR_DBNAME_HERE')

or

This Blog entry contains information on how to do it on SQL Server 2008 and 2005.
http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx [http://sqlblog.com/blogs/aaron_bertrand/archive/2008/05/06/when-was-my-database-table-last-accessed.aspx]

<div>
Thanks Jayaraj,<br />
<br />
Will it work for MySQL ?<br />
<br />
<br />
Regards.<br />
Sreeni
</div>


Thanks Jayaraj,

Will it work for MySQL ?


Regards.
Sreeni

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Could some body provide me query to find last updated of the database in mYSQL.<br />
<br />
Regards,<br />
Sreeni
</div>
</div>


Hi All,

Could some body provide me query to find last updated of the database in mYSQL.

Regards,
Sreeni

Query for last database updated date in MySQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.