I want to know on which date MySql is last updated?

[amit]

I want to know on which date MySql is last updated? What is the function for this?

[rgermain]

If you use the field type timestamp it keeps track of the last time a record was updated.

[dagon]

$info = mysql_fetch_array(mysql_query("show table status from $database_name like $table_name"));
$table_date = $info["Update_time"];

pass $table_date through date() for a friendly format