Ive been trying to find out how to write a query like this for months now and feel its time that I get some help
Im trying to export columns to text files so that they can be accessed via a website to show statistics.
(My SQL database is used for something else and I do not want the website directly connecting to it.)
So first I would have the table ordered by a specific column and then export the top 50 results for example.
I had it working to export to excell but I lost the query
Do I use something like EXPORT COLUMNS or INSERT INTO text file sorta thing