FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin para Harbour/xHarbour mysql - data ultima atualização de um tabela
Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM
mysql - data ultima atualização de um tabela
Posted: Fri Sep 09, 2011 08:49 PM

É possível saber a data da última atualização de um tabela mysql?

Tentei assim:

show table status like "tabela";

porem me retorna:

update_time = NULL

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
Posts: 1054
Joined: Sun Oct 09, 2005 10:41 PM
Re: mysql - data ultima atualização de um tabela
Posted: Sat Sep 10, 2011 04:16 PM

Hi, :
When the data file was last updated. For some storage engines, this value is NULL. For example, InnoDB stores multiple tables in its tablespace and the data file timestamp does not apply. For MyISAM, the data file timestamp is used; however, on Windows the timestamp is not updated by updates so the value is inaccurate.
(MySQL)

Posts: 1286
Joined: Mon Feb 25, 2008 02:54 PM
Re: mysql - data ultima atualização de um tabela
Posted: Mon Sep 12, 2011 10:49 AM

muito obrigado Willi

ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin

Continue the discussion