Hello, i am trying to run the code "DELETE FROM player WHERE damage = 1" every min, if i run this code it works, but when i create an event it never runs.
this is what i see when i create the event:
SELECT DEFAULT_COLLATION_NAME
FROM information_schema
.SCHEMATA
WHERE SCHEMA_NAME
='exile';
SHOW TABLE STATUS FROM exile
;
SHOW FUNCTION STATUS WHERE Db
='exile';
SHOW PROCEDURE STATUS WHERE Db
='exile';
SHOW TRIGGERS FROM exile
;
SELECT , EVENT_SCHEMA AS Db
, EVENT_NAME AS Name
FROM information_schema.EVENTS
WHERE EVENT_SCHEMA
='exile';
/ Entering session "exile" */
Thanks in advance