On 2015-05-07, at 07:17, mysql-digest-h...@lists.mysql.com wrote:
> I have, however, also had Martin's experience where create_time seemed
> improbable.
Sigh. I have the same thought every evening, when I look over all the things I
planned to do during the day...
Compared to
> 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
> >create_time seemed improbable; and the structure is unlikely to have
'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
...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, thoug
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
&
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
That’s not quite an answer to the question I asked. Does “create_time”
represent the date at which a table was created, and does that date change or
stay the same if there is an update on the table or columns are removed or
added?
I had an experience where a table that I knew to be several
Hi Martin,
which table are you looking at from information_schema?
TABLES table should give you the correct information based on CREATE_TIME
column, also if you check for show table status like 'table_name'; gives
you the right information.
On Fri, May 1, 2015 at 3:12 AM, Mart
I had thought that MySQL remembers the date when a table is first created
and stores it in the create_time column of Information Schema. But this
doesn¹t seem to be the case.On my machine it seems to record the date of
most recent access. Which seems odd.
Am I doing something wrong? Is there a
Hello all,
Is there a way to change a table's Create_time that is displayed when
doing a `SHOW TABLE STATUS FROM mydb LIKE 'foo'\G`?
I've tried using touch to modify the file dates directly and searched
the online docs with no luck.
The reason I want to do this is becaus
10 matches
Mail list logo
