Not sure this belongs here, sent it to MySQL as well. If anyone has any
tips in general about mysql on LM 7.0 (or newer), shoot em out my way:
Doing some warehouse style queries on some tables, and this query just
ain't working:
select sum(smp.length/ml.minutes_in_month)
, a.asset_class
, smp.row_month
from smp , month_lengths ml , asset_class a
where smp.row_month = ml.row_month
and a.asset_short_name = smp.asset_short_name
group by a.asset_class
, smp.row_month
into outfile '/temp/raw/percent_time_marginal_by_class.tdel';
Am I not write or should I get ONE row per value of a.asset_class and
smp.row_month, whatever the result? This puzzles me, as I seem to be
getting a lot of rows per value here (looks like one for each row in the
query)? I also can not group by a function column (ie
substring(process_date,1,7) as pmonth.
Is this not possible in MySQL??
System is Linux Mandrake 7.0 Mysql version:
mysqladmin Ver 5.3 Distrib 3.20.32a, for pc-linux-gnu on i686
I am downloading current version to try that....
