-
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
-
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
-
Forum Rules
|
|