I am using CSV under DBI. A select statement with "group by" always gives me error: ex:
"SELECT AVG(id), MIN(id), MAX(id) FROM $table WHERE NOT (id IS NULL) GROUP BY name" SQL ERROR: Bad table or column name 'NULL GROUP BY name' has chars not alphanume ric or underscore! It works fine with "group by" clause removed. Looks like CSV does not support group by. Is there a way that I can do "group by" with CSV or DBD? Thanks Ming