GFY MySQL gurus!

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rhesus
    Confirmed User
    • Aug 2004
    • 2009
    #1

    GFY MySQL gurus!

    What query should I run if I want to do this:

    Export the contents of ColumnA of table Database1.Table1 into locally stored txt file /usr/home/blah/text.txt, one new entry per line?

    Many thanks in advance!
    Tags: None
    • psili
      Confirmed User
      • Apr 2003
      • 5526
      #2
      Look into "select into outfile"

      Code:
      SELECT * INTO OUTFILE '/tmp/dump.txt' FROM img
      http://elib.cs.berkeley.edu/admin/mysql/syntax.html
      Your post count means nothing.

        Comment

        • Rhesus
          Confirmed User
          • Aug 2004
          • 2009
          #3
          Thanks :-)

            Comment

            Previous template Next
            Working...