Hi I'm making an event that runs every minute and extracts certain columns on a table and creates an output-file in excel format
Since I cannot overwrite the file, i wanted to append a time-stamp on the filename so it will create unique excel filenames.
Here is the sample of my event
CREATE EVENT IF NOT EXISTS
'Extract_Users'
ON SCHEDULE EVERY 1 Minute
COMMENT 'Data Extraction' DO SELECT userID, email, id FROM table_one.user_name
INTO OUTFILE 'C:\path\path\Desktop\test\user.xls'
Thank you!