Can we make memory table in jasper report?that mean....

[adasi]

Hey..............

We can make memory table in MySQL  lake below..

 

mysql> CREATE TABLE test ENGINE=MEMORY    ->     SELECT ip,SUM(downloads) AS down    ->     FROM log_table GROUP BY ip;mysql> SELECT COUNT(ip),AVG(down) FROM test;mysql> DROP TABLE test;[/code]

[/code]

But when we get memory table detail to the jasper report.That mean when we build jasper reportwe want to write report query..so we want to make above query in jasper report..How can we do that?[/code]

Post Edited by adasi at 08/10/2011 16:39

[svenn]

I'm pretty sure the query window only supports select statements

Post Edited by svenn at 08/10/2011 17:17

[adasi]

Hey...

 

Is there a eny method  to get  MyQSL  memory  table  value to the jasper report....

 

[szaharia]

Hi,

Is it essential to use those in-memory tables? An equivalent query would have the same results.

HTH,

sanda

Code:

SELECT COUNT(ip),AVG(down) FROM (SELECT ip,SUM(downloads) AS downFROM log_table GROUP BY ip) as test