Store SQL query results returned from the Server

Question

I am using Sequel pro to connect to a remote server on which the mysql database is running. I am using Mac and the server has Linux installed. I want to store that result (i.e. the table that you can see in the picture) as a text file on my Mac. How can I do that? Attached is the screen shot of my query in sequel pro.

Answer 1

After you have run the query you can export it under "Datei"-> Export and select the fileformat that you want