Web lists-archives.com

Re: create_time




update_time column works for MyISAM, not for InnoDB.

On Mon, May 4, 2015 at 10:19 PM, Martin Mueller <
martinmueller@xxxxxxxxxxxxxxxx> 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" <vegivamp@xxxxxxxxx> 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" <vegivamp@xxxxxxxxx>
> >> To: "Pothanaboyina Trimurthy" <skd.trimurthy@xxxxxxxxx>
> >> Cc: "Martin Mueller" <martinmueller@xxxxxxxxxxxxxxxx>, "MySql"
> >><mysql@xxxxxxxxxxxxxxx>
> >> 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
>
>