[PHP-DB] Formatting MySQL Queries

2007-01-24 Thread Brent Anderson 

Hello.

My team and I are looking for a way to return an entire table of  
MySQL data with columns delimited by tabs and rows delimited by  
carriage returns. How exactly would this work - I'm not a PHP expert  
and, although I know MySQL, I don't know where to begin with  
formatting a query pointer into an actual pile of text. We have an  
engine ready to take tables in this format for processing, we just  
need to parse the query data into a text result.


Thanks,
Brent Anderson

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Formatting MySQL Queries

2007-01-24 Thread Niel Archer 
Hi

SELECT * FROM table INTO OUTFILE 'file_name'
  FIELDS TERMINATED BY '\t'
  LINES TERMINATED BY '\n'


Niel

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php