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 sitting
That sounds logical. I have, however, also had Martin's experience where
create_time seemed improbable;
- Original Message -
From: Pothanaboyina Trimurthy skd.trimur...@gmail.com
To: Martin Mueller martinmuel...@northwestern.edu
Cc: MySql mysql@lists.mysql.com
Sent: Friday, 1 May
...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
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
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
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_time
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, Martin Mueller
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
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 because we had some tables
10 matches
Mail list logo