SELECT cols FROM tbl INTO OUTFILE '/someflie';

ollie wrote:
> 
> Does anyone have a way to export data from a table into a tab delimited text
> file? Can't seem to see the option in mysqldump.
> 
> For bonus points - how could I achieve this via PHP?(!)
> 
> TIA,
> 
> ollie
> 
> ----------------------------------------------------------------------------
> or-media.com  | design | online | interactive | 3d | animation | video
> +44 (0) 207 394 1072
> 
> ---------------------------------------------------------------------
> 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

-- 
Colin Faber
(303) 736-5160
fpsn.net, Inc.

---------------------------------------------------------------------
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

Reply via email to