Section 4.11.6.1. Example: CloseSessionQuery

Example: `CloseSessionQuery`

In the following example query, bind variables marked with question marks are used with CloseSessionQueryParams listed below the query.

CloseSessionQuery UPDATE sessions SET stop_time=? WHERE id=?
CloseSessionQueryParam %t
CloseSessionQueryParam %0

Instead of the updating session stop timestamp, it's also possible to remove old sessions.

CloseSessionQuery DELETE FROM sessions WHERE id=?
CloseSessionQueryParam %0