That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable;
----- Original Message ----- > From: "Pothanaboyina Trimurthy" <skd.trimur...@gmail.com> > To: "Martin Mueller" <martinmuel...@northwestern.edu> > Cc: "MySql" <mysql@lists.mysql.com> > Sent: Friday, 1 May, 2015 17:13:27 > Subject: Re: create_time > If you run any DDL (add column, drop column etc..) commands against > particular table then create_time will update to the latest time when the > DDL performed. > > If you run any DML statements (insert,update,delete), then update_time > colum's value chages, If you restart the DB instance then update_time > columns will be set to NULL till you run the first query against that > particular table after the reboot. -- Unhappiness is discouraged and will be corrected with kitten pictures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql