Hello my problem is that I do not know if it is possible to show a message through an EVENT of MySQL since the only way that I see is that the message is saved in a specific table for that message but I can not show it in the table with the event. If there is a way to show messages, I would appreciate it if you could explain.
Basically, if I get an exercise that shows the time every five minutes and how I could do it. Showing the time because what I have done does it but only saves the record in a table I leave the code.
DELIMITER :
CREATE TABLE HORA (HORA_ACTUAL VARCHAR(65)):
SET GLOBAL event_scheduler=ON:
CREATE EVENT RecHor_ej1
ON SCHEDULE EVERY 5 MINUTE
STARTS NOW()
ENDS NOW() + INTERVAL 15 MINUTE ENABLE DO
BEGIN
DECLARE VAR VARCHAR(65);
SET VAR=(SELECT CONCAT('Hora actual ',CURTIME()));
INSERT INTO HORA VALUE (VAR);
END:
I am a newbie in this of the events and in general in the, undo of MySQL I appreciate your help. : D