#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    3
    Rep Power
    0
    Please tell me how to export a MySQL table to a pipe delimited file ...
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Posts
    3
    Rep Power
    0
    Got it....

    SELECT * FROM TABLE ORDER BY ID INTO OUTFILE 'out.file' FIELDS TERMINATED BY '|';

Similar Threads

  1. Replies: 3
    Last Post: January 28th, 2010, 02:14 PM
  2. Replies: 1
    Last Post: January 24th, 2004, 12:20 PM
  3. test for mySQL table
    By Splendid_Bob in forum PHP Development
    Replies: 4
    Last Post: July 12th, 2002, 07:50 AM
  4. Replies: 9
    Last Post: July 8th, 2002, 09:46 AM
  5. reordering rows in mysql table
    By amanda in forum MySQL Help
    Replies: 4
    Last Post: January 7th, 2002, 06:49 PM

IMN logo majestic logo threadwatch logo seochat tools logo