konto usunięte
Temat: Problem z triggerem
Witam!Co tu mam źle? Sam trigger się tworzy, ale przy dodawaniu inserta dostaję błąd...:
Can't update table 'cms_sessions' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
CREATE TRIGGER `delete_session_history` AFTER INSERT ON `cms_sessions`
FOR EACH ROW BEGIN
DELETE
FROM cms_sessions
WHERE last_activity<(UNIX_TIMESTAMP()-2592000);
END