to delete old sessions.

[Leon]

Hi,
I wish to delete old sessions in a web application. Presently, I am hard wiring the time interval to two hours and using the following query.

DELETE Sessions
WHERE DATE_ADD(Sessions.LastAccessedOn, INTERVAL 2 HOUR) >= CURRENT_TIMESTAMP();

This query is a part of a stored procedure and I am syntax error. Can somebody help me get the syntax right ?

Thank You. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

One thing to note down is that the DATE_ADD function only works with dates. Try using the SUBTIME() function. Also, this syntax below compares a column value against a value that can be calculated once each time the query is run and enables the use of an index on LastAccessedOn if there is one, to increase performance. Also I think you had your original comparison logic backward.

DELETE FROM Sessions
WHERE Sessions.LastAccessedOn <= SUBTIME(CURRENT_TIMESTAMP(), '02:00:00'); -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --