MySQL question# Database - 数据库
o*e
1 楼
How to output the selected table records into a file?
I try to use:
SELECT * FROM MY_TABLE INTO OUTFILE 'out.txt'
FIELDS TERMINATED BY ',';
But the error msg told me access denied. The default
path is the current directory for the output file?
What kind of permission is expected to be set for the
directory? How about if the file is already there, do
I need to del first?
never use MySQL b4.
Thanks for help.
I try to use:
SELECT * FROM MY_TABLE INTO OUTFILE 'out.txt'
FIELDS TERMINATED BY ',';
But the error msg told me access denied. The default
path is the current directory for the output file?
What kind of permission is expected to be set for the
directory? How about if the file is already there, do
I need to del first?
never use MySQL b4.
Thanks for help.