Re: create_time

2015-05-04 Thread Gary Armani
update_time column works for MyISAM, not for InnoDB. On Mon, May 4, 2015 at 10:19 PM, Martin Mueller < martinmuel...@northwestern.edu> wrote: > So, if you want to have a permanent record of when a table was > created‹never mind subsequent adjustments, you should personally enter the > data as a t

Re: create_time

2015-05-04 Thread Martin Mueller
So, if you want to have a permanent record of when a table was created‹never mind subsequent adjustments, you should personally enter the data as a table comment? On 5/4/15, 9:13 AM, "Johan De Meersman" wrote: >...sigh. > >That sounds logical. I have, however, also had Martin's experience where

Re: create_time

2015-05-04 Thread Johan De Meersman
...sigh. That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable; and the structure is unlikely to have changed without my knowledge as user accounts don't have DML privileges. I didn't pay any further attention to it, though, as it wasn't importan

Re: create_time

2015-05-04 Thread Johan De Meersman
That sounds logical. I have, however, also had Martin's experience where create_time seemed improbable; - Original Message - > From: "Pothanaboyina Trimurthy" > To: "Martin Mueller" > Cc: "MySql" > Sent: Friday, 1 May, 2015 17:13:27 > Subject: Re: create_time > If you run any DDL (ad