← Back to team overview

maria-discuss team mailing list archive

Re: Doubts about temporal table

 

Hi, Roberto!

On Jun 08, Roberto Spadim wrote:
> Hi folks
> 
> Could be possible query temporal tables but instead of use a timestamp, use
> a “commit” id?
> 
> For example query first commit, second, third, ... and the last commit =
> current table?

Yes.
See https://mariadb.com/kb/en/temporal-data-tables/#transaction-precise-history-in-innodb

Regards,
Sergei
VP of MariaDB Server Engineering
and security@xxxxxxxxxxx


Follow ups

References