I want to use MySQL Routine to export the result of a query into a file on Linux. I'm just wondering if this is possible? Thanks.
The reason why I want to use MySQL Routine is because I have already had a routine running periodically to performance a data transformation. I just want this export as part of this process.