Entry

How can I export the results of a MySQL query into a text file?

Jun 28th, 1999 01:31
Nathan Wallace, Padraic

Try the SELECT ... INTO OUTFILE syntax. See

    http://www.mysql.net/Manual_chapter/manual_Reference.html#SELECT

for more info. You can set the output filename, as well as other
options.