[SLUG] Dumping mySQL output into text files.
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 Group (NSW) Pty Ltd p: (02) 9955 8000
Re: [SLUG] Dumping mySQL output into text files.
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, part of the normal mysql distribution -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Dumping mySQL output into text files.
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 can be easily dumped into a mail out. mysqldump, part of the normal mysql distribution Using the 'mysql -e' command gives a bit more flexibility in the output you can have. eg, mysql -e SELECT username, emailaddr FROM tablename dbname Regards, Craig Ayliffe -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
Re: [SLUG] Dumping mySQL output into text files.
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 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 Group (NSW) Pty Ltd p: (02) 9955 8000 -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug