SHOW
statement
SHOW
statement
The SHOW
statement can be used to replay changes made to the table.
Statement syntax
SHOW CHANGES FOR TABLE @tableName [SINCE "@timestamp"] [LIMIT @number]
Example usage
Basic usage
The following expression shows usugae of Show statment.
-- Replay changes to the reading table
SHOW CHANGES FOR TABLE reading SINCE "2023-09-07T01:23:52Z" LIMIT 10