Craig Newlander wrote:
> Hello,
> How can I execute query and have it's output (just data, no structure)
> saved to a CSV file?
> Thanks,
>From the command line? AFAIK mysql will only output tab separated results
so you have to do something like:
echo "SELECT 'a', 'b', 1" |mysql db |perl -n
Hello,
How can I execute query and have it's output (just data, no structure)
saved to a CSV file?
Thanks,
Craig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/