[thelist] generating output from select statement.

Dan McCullough dan.mccullough at gmail.com
Mon Jan 31 10:38:40 CST 2005


been looking all over for this, and somehow I seem to be missing it.
select record1","record3","record2","record8","record4","record6","record10
from dealer where email not like 'test at test.com';

mysql -s database < query.sql > output.txt

which should output a text file with

data1,data3,data2,data8,data4,data6,data10
data1,data3,data2,data8,data4,data6,data10
data1,data3,data2,data8,data4,data6,data10
data1,data3,data2,data8,data4,data6,data10
data1,data3,data2,data8,data4,data6,data10
...

what do I seem to be doing wrong?


More information about the thelist mailing list