How does temporal tables work in Mysql?
In microsoft sql server (t-sql), temporal table query is: CREATE TABLE Department ( DeptID INT NOT NULL PRIMARY KEY CLUSTERED , DeptName VARCHAR(50) NOT NULL , ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL , ValidTo DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL , PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) ) WITH (SYSTEM_VERSIONING = ON); What is the equivalent in mysql temporal table query as i am new to my sql?
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)