[SLUG] Dumping mySQL output into text files.

2003-03-27 Thread mkraus
G'day... As per the subject line. Anyone know of a simple way of doing this. I've an database of user details and email addresses and want to output the emails into a flat file so they can be easily dumped into a mail out. Thanks... Mike --- Michael S. E. Kraus Administration Capital Holdings

Re: [SLUG] Dumping mySQL output into text files.

2003-03-27 Thread Tony Green
On Fri, 2003-03-28 at 11:08, [EMAIL PROTECTED] wrote: G'day... As per the subject line. Anyone know of a simple way of doing this. I've an database of user details and email addresses and want to output the emails into a flat file so they can be easily dumped into a mail out. mysqldump,

Re: [SLUG] Dumping mySQL output into text files.

2003-03-27 Thread Craig Ayliffe
On Fri, 2003-03-28 at 11:18, Tony Green wrote: On Fri, 2003-03-28 at 11:08, [EMAIL PROTECTED] wrote: G'day... As per the subject line. Anyone know of a simple way of doing this. I've an database of user details and email addresses and want to output the emails into a flat file so they

Re: [SLUG] Dumping mySQL output into text files.

2003-03-27 Thread wm
part of normal select syntax? SELECT a,b,a+b INTO OUTFILE /tmp/result.text FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n FROM test_table; On Fri, 28 Mar 2003 11:08, [EMAIL PROTECTED] wrote: G'day... As per the subject line. Anyone know of a simple way of doing