At 10:34 -0900 3/16/03, Tim Johnson wrote:
Hi Paul:
* Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]:
At 9:14 -0900 3/16/03, Tim Johnson wrote:
>Hello All:
> I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
> I believe that INTO LOCAL OUTFILE is not implemented, but
> all the same, I would like to save a selection set into
> a local output (text) file. Can someone suggest a way to
> use mysqldump to do the same (or any other strategy).
>
> I've tried using the --tab option but get am getting
> Errcode: 13
There is no analog to INTO LOCAL OUTFILE. You can save the output
of a query executed in mysql to a file, which will give you a tab-delimited
file. In some cases, that may be sufficient.
mysql -e "select * from tbl_name" db_name > output
Paul, that works just fine. I note that column names
are inserted as the first line. Is there a way to eliminate
that? If not, that is just fine.
Yes, use either the --skip-column-names or -N option. Alternatively,
use -ss ("double silent"), but's mainly for versions older then 3.22.20
that don't support --skip-column-names/-N.
Thank you very much
-tim-
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
--
Paul DuBois
http://www.kitebird.com/
sql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
