Querying to a TXT file

[ironmunk]

Hi, is there a way to run a query in MYSQL but have the output to a txt file? (maybe .CSV)?

thx.

ps. through the phpmyadmin interface.

 

[bMindful]

I could be wrong, but phpMyAdmin does not support outputting query results other than as HTML. Entire data structures can be exported in any fashion, but not individual queries. I could see how such a feature could be handy for GUI only-users.

Of course with the programming language of your choice you could query the db directly and write the results to a file on that server however you wanted. Maybe someone is smarter than me has a clever idea

 

[tshot]

SELECT * INTO OUTFILE MyOutput.TXT
	FIELDS TERMINATED BY ","
	FROM MyFile
	WHERE Condition = MyCondition

----------------
ur feedback is a very welcome desire

 

[tshot]

Sorry u said PHPMyadmin. I did not see that. I have never used it However with MySql Front there is an option to copys as CSV




----------------
ur feedback is a very welcome desire