更新时间:2023-12-01 15:56:46
我有很多表
您可以使用名为lastModified的外部表,并在每个插入更新删除操作中使用db触发器,并在上述操作中更新表.
you can use an external table called lastModified and use a db trigger in every insert update delete operation and update the table on above operations.
现在映射一个具有唯一ID的表名,并在每个操作中更新记录lastUpdatedTime列.
now map a table name with a unique id and update the record lastUpdatedTime column in every operation.
获取按时间顺序排列的第一条结果记录.
get the first record of result ordered by time.
这将是最后更新的表.
表格格式
| id | table_name | last_updated_time |