[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