Andy,
You can use a standard SELECT implementing the INTO OUTFILE... clause. Just
remember to use fully qualified paths with that file since it default to the
mysql DB directory.
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [DISTINCT | ALL]
select_expression,...
[INTO OUTFILE 'file_name' export_options]
[FROM table_references
[WHERE where_definition]
[GROUP BY col_name,...]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
[PROCEDURE procedure_name] ]
-Eric.
Andy Harrison: [Thursday 1-April]:
> 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!
>
--
Eric Berg
Chief Technical Officer, iParty Corp. eberg@stripped
Vice President, New York Linux Users Group eberg@stripped
work: 212-331-1229 http://doobie.iparty.com
home: 212-721-2872
