Timestamps and TTLs

Author: Al-mamun Sarkar Date: 2020-09-22 07:14:33

In this lesson, I will show you how to get insert or update of a column and how to add TTL on update and insert query.

 

Getting writetime of a column:

SELECT city, name, writetime(name) 
FROM employees;

 

Adding TTL (Time To Live) on Update query:

UPDATE employees USING TTL 30 SET name='Bob' WHERE id = 1;

Column will be deleted after given seconds here 30 seconds.

 

Using TTL on Insert Query:

INSERT INTO employees (id, city, name) 
VALUES ( 4, 'Rangpur', 'Jon Doe') 
USING TTL 20;