Converting MYSQL data to straight text

[sir pannels]

Hey :)
Hmm ok ive got a loads of entries from an old mysql db ... i want to convert the data in them to txt files.. so it puts the data from a certian field into a text file each.
ideas?
Cheers ;)
-P-:thumbsup:

[bcarl314]

at the mysql prompt type the following:

mysql> tee c:\myFileFromMyTable
mysql> select * from myTable;
// you'll see the contents of your table here
.
.
.
mysql> tee off

then open the file c:\myFileFromMyTable

That should do it for you.