Php or mysql commands - data from mysql row into text file

Question

How do I get all data from one row from mysql table exported into text files, but formatted this way:

• one field under another, one per line
• i would like to break that data into pieces and save for example 50 lines in file1.txt then next 50 in file2.txt and so on until end (it's not round number so last file would have less lines probably)
• don't copy identical entries / remove duplicates

...using php script or just mysql console?

Answer 1

I hate doing peoples homework/work, but this one is just too easy.

 <?

 $row = mysql_fetch_array($rc);

 $nodupes = array();
 foreach ($row as $field)
 {
  $nodupes[$field] = $field;
 }

 $i = 1;
 $filenum = 0;
 $line = 50 ; // create new file ever 50 lines
            $text = "";
 foreach($nodupes as $field)
 {
  $i++;
  $text .= "$field\n";

  // to split into bite size peices
  if ($i % $line == 0)
  {
   $filenum++;
   $filename = "myfile_$filenum.txt";
   file_put_contents($filename,$text);
   $text = "";
  }
 }
 $filenum++;
 $filename = "myfile_$filenum.txt";
 file_put_contents($filename,$text);
 ?>

So eat today, and learn to fish another day!

Answer 2

I might do it this way, using the command-line client:

$ mysql --user=XXX --password=XXX --batch --skip-column-names \
  -e "SELECT userid, displayname FROM Users" stackoverflowdb | \
split -l 50 -a 5 - "result."