dump data outfile????

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • picaza

    dump data outfile????

    hi,

    is there a way to dump just data to a file similar to the way "load data
    infile" reads data?

    tia,
    peter

  • pekka

    #2
    Re: dump data outfile????

    hi

    yes, there is:

    select * from <file> into outfile "file.out";



    picaza wrote:
    [color=blue]
    > hi,
    >
    > is there a way to dump just data to a file similar to the way "load data
    > infile" reads data?
    >
    > tia,
    > peter
    >[/color]

    --
    pexi

    Outoa, kaikki älykkäät ihmiset ovat samaa mieltä kanssani.

    Comment

    • picaza

      #3
      Re: dump data outfile????



      pekka wrote:
      [color=blue]
      > select * from <file> into outfile "file.out";[/color]

      thanks,
      i also found the "dump" function in the perl DBI mod.

      peter

      Comment

      Working...