update_time column works for MyISAM, not for InnoDB. On Mon, May 4, 2015 at 10:19 PM, Martin Mueller < [email protected]> 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 table comment? > > On 5/4/15, 9:13 AM, "Johan De Meersman" <[email protected]> wrote: > > >...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 important > >to me at the time. I'll be monitoring this thread with interest :-) > > > > > >----- Original Message ----- > >> From: "Johan De Meersman" <[email protected]> > >> To: "Pothanaboyina Trimurthy" <[email protected]> > >> Cc: "Martin Mueller" <[email protected]>, "MySql" > >><[email protected]> > >> Sent: Monday, 4 May, 2015 16:11:24 > >> Subject: Re: create_time > > > >> That sounds logical. I have, however, also had Martin's experience where > >> create_time seemed improbable; > > > >-- > >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 > >
