SELECT * INTO OUTFILE "/dir/they/can/get/to" FROM TABLE WHERE
<yada|yada>

DVP
----
Dathan Vance Pattishall     http://www.friendster.com

 

> -----Original Message-----
> From: H Ba [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, March 03, 2005 11:15 AM
> To: mysql@lists.mysql.com
> Subject: DB Export multiple tables to CSV
> 
> I have multiple tables set up and need to export these to csv 
> in order to import them into Excel. Since all tables are 
> related to each other and I can only export one at a time, is 
> there a way to somehow get a "readable" file after importing 
> into Excel, which non-programmers can edit and use for 
> further processing?
> 
> Regards,
> Holger
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to