AUTO-DELETE ROW 1 Day After Inserted (MySQL)

Question

How to create event Auto-Delete some row 1 day after inserting that row?

I have 3 fields:

• id varchar

• name varchar

• timestamp current_timestamp()

Answer 1

Here's your scripts.

Insert into table1 (id, name, timestamp) values (1, 'test', now())

after insert

Delete from table1 WHERE timestamp < now() - interval 1 day;