Web lists-archives.com

Re: create_time




That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable; 

----- Original Message -----
> From: "Pothanaboyina Trimurthy" <skd.trimurthy@xxxxxxxxx>
> To: "Martin Mueller" <martinmueller@xxxxxxxxxxxxxxxx>
> Cc: "MySql" <mysql@xxxxxxxxxxxxxxx>
> 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