Is there a way to get mysql scripts to delete txt files on a server. I use a select into outfile query to create txt files with data from my database. I would also like to be able to delete those with a query as well. Any ideas?
you wouldn't use MySQL to delete a text file on a server (to my knowledge no such functionality exists within MySQL to do this). You'd use either an operating system command in the script (DOS or Linux) or a function in a language like PHP or PERL.