Results 1 to 2 of 2

Thread: Select Into Outfile

  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Select Into Outfile

    When i try
    SELECT * INTO OUTFILE 'data_out.txt'
    FIELDS TERMINATED BY '\t'
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\r\n'
    FROM Lib_Master;

    i couldn't find the file data_out.txt.
    where it will be located?

    thanx in advance

  2. #2
    Join Date
    Dec 2002
    Location
    Cape Town, South Africa
    Posts
    75
    By default it's put into the MySQL data directory. Where this is depends on your installation. You can run
    SHOW VARIABLES LIKE 'datadir';
    to find out if you're not sure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •