List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 13 1999 11:03pm
Subject:Re: exporting data
View as plain text  
On Mon, 1999-09-13 15:48:36 -0700, Dan Wade wrote:
> I have but I have a table of 100 or so records that I need to export
> to a tab-delim txt file.
> 
> How can I do this?

See MySQL Reference Manual, chapter "7.11 SELECT syntax", and look for
the last paragraph on "INTO OUTFILE".

Also see chapter "7.15 LOAD DATA INFILE syntax" for some helpful
explanations.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
exporting dataDan Wade14 Sep
  • Re: exporting dataMartin Ramsch14 Sep
  • Re: exporting dataBob Kline14 Sep
RE: exporting dataJohn Millaway14 Sep