List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:April 1 1999 4:51pm
Subject:Re: Dump format question
View as plain text  
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


Thread
Dump format questionAndy Harrison1 Apr
  • Re: Dump format questionEric Berg1 Apr
Re: Dump format questionChristopher R. Jones1 Apr