Please see MySQL statement used to delete records older than one minute. Can you please explain the usage of INTERVAL in the given statement?

DELETE FROM `token_tbl` WHERE `dateCreate` < (Now() - INTERVAL 1 MINUTE)

CodePudding user response：

interval denotes a period of time. I.e., Now() - INTERVAL 1 MINUTE means "one minute before the current time". Then the condition would be any records that have dateCreate that are older than a minute ago.