I’m a Rails newbie and i have some problem.
I’m using MySQL.
I want to excute some complexity query,
and I need to create some table to hold temp query result.
I want to know how to execute some SQL query such like
"CREATE TEMPORARY TABLE templist SELECT * FROM table2 "
I’ve tried to excute find_by_sql("create table templist select * …),
but it seem to return a nil object , so that rails will halt.
any tips is appreciated.