Well, the tricky part is the "after 5 minutes" requirement. Can you schedule any command on the server - actually this depends on the access level you have and/or the services your hosting partner provides. If not, you can use the "poor man's crone" approach: you don't delete the data exactly after that 5 minutes, but at the first request processing after the expiration of this interval.
The idea is the following in both cases:
1) add a timestamp to your table, and set it on insert to the current timestamp value, let's call it TS:
CREATE TABLE myTable
(
TS TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
//rest of the table declaration
);
On insert, just omit this field.
2) when processing any request / or at schedule, just run following command:
DELETE FROM myTable WHERE TIMESTAMPDIFF(MINUTE,TS,CURRENT_TIMESTAMP)>5
Submit an article or tip