See the manual Section 7.15:
SELECT field1, field2 FROM table1 INTO OUTFILE 'your_textfile';
At 02:54 PM 4/1/99 +0000, you wrote:
>For someone who knows how, this is probably a quick question.
>
>
>I have a table with 12 different fields with one of them a primary. I'd
>like to be able to dump all rows but only 3 of those fields to a tab
>delim text file, with no field delim.
>
>Can anyone help me out?
>
>TIA!
>
>
>--
>
> .==,_
> .===,_`\ Andy Harrison
> .====,_ ` \ .====,__
> --- .==-,`~. \ `:`.__, __
> --- `~~=-. \ /^^^ / / __ _ _ _ _ __ __
> --- `~~=. \ / / /__ / / / \// //_// \ \/ /
> `~. \ / /____/ /_/ /_/\/ /___/ /_/\_\
> ~. \____./ ...for IQs GREATER than 98...
> `.=====
> ___.--~~~--.__
> ___\.--~~~ ~~~---.._|/
> ~~~" /
>
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread1269@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>
>
>
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
