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?

Bill Karwin · Accepted Answer · 2009-08-07 21:35:52Z

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."

answered Aug 7, 2009 at 21:35

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Byron Whitlock Over a year ago

+1 Very cool. Reminids of those great perl one liners. Oh yeah, you forgot the distinct ;)

Bill Karwin Over a year ago

Heh! See my favorite Perl hack here: stackoverflow.com/questions/303876/…

Byron Whitlock · Accepted Answer · 2009-08-07 21:30:21Z

0

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!

answered Aug 7, 2009 at 21:30

Byron Whitlock

54.2k29 gold badges128 silver badges170 bronze badges

4 Comments

Henrik P. Hessel Over a year ago

So, he's going to copy & paste it and learned nothing :) But you damn right *g

Byron Whitlock Over a year ago

You can't copy and paste forever. Eventually he will either learn, or hire someone like you or I to clean up his mess.

mpen Over a year ago

I'd have used a 'SELECT DISTINCT' rather than manually remove the dupes, or at the very least, use PHP's built in array_unique.

Phil Over a year ago

it's neither work nor homework ;), i'm trying to learn on sample database

Collectives™ on Stack Overflow

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

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related