Mysql: how to extract multiple text files from my mysql table
- by Patrick
hi,
I need to extract data from my mysql database into multiple text files.
I have a table with 4 columns: UserID, UserName, Tag, Score.
I need to create a text file for each Tag, with the userID, the userName and score (ordered by score)
i.e.
Tag1.txt
234922 John 35
234294 David 205
392423 Patrick 21
Tag2.txt
234922 John 35
234294 David 205
392423 Patrick 21
and so on...
Edited: Sample: http://dl.dropbox.com/u/72686/expertsTable.png
thanks