mysql -h hostname.com -u user -p dbname --execute="select DISTINCT(column_name) from tablename" > file.txt

Written by Matt Cooper
Hi, I'm Matt Cooper. I started this blog to pretty much act as a brain dump area for things I learn from day to day. You can contact me at: matt@linuxtutorial.co.uk.