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