o*******e 发帖数: 31 | 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. | c********e 发帖数: 417 | 2 When I was trying to link object files, I always had an error message.
The command line is:
gcc -o a.out program.c -L/usr/local/mysql/lib -lmysqlclient
The erro message is:
/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function
`my_uncompress`:
my_compress.o(.text+0x9a): undefined reference to `uncompress`
/usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In function
`my_compress_alloc`:
my_compress.o(.text+0x9a): undefined reference to `compress`.
Why did this happen? Is that b |
|