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 table comment? > > On 5/4/15, 9:13 AM, "Johan De Meersman" <vegiv...@tuxera.be> 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" <vegiv...@tuxera.be> > >> To: "Pothanaboyina Trimurthy" <skd.trimur...@gmail.com> > >> Cc: "Martin Mueller" <martinmuel...@northwestern.edu>, "MySql" > >><mysql@lists.mysql.com> > >> 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 > >