Temporal Tables
Explore temporal tables in MariaDB Server. This section details how to manage data with system-versioning and application-time periods, enabling historical data tracking and time-aware queries.
Last updated
Was this helpful?
Explore temporal tables in MariaDB Server. This section details how to manage data with system-versioning and application-time periods, enabling historical data tracking and time-aware queries.
Application-time period tables define a time period between two temporal columns, for application-level data versioning.
Bitemporal tables combine system-versioning and application-time periods, versioning data at both levels.
Complete system-versioned tables: WITH SYSTEM VERSIONING syntax, FOR SYSTEM_TIME AS OF/BETWEEN/ALL queries, and ROW_START/ROW_END columns.
Last updated
Was this helpful?
Was this helpful?