Result query more than one record?
Posted by:
Macamba .
Date: April 09, 2017 05:33AM
In my Java application I query, and get back one record. What if a new query gets back more records, like a table?
For instance:
SELECT `project`,`activity,
SEC_TO_TIME(SUM( TIME_TO_SEC(`worked_time`)))
FROM `projects`
WHERE `day` <= "2017-04-09" # Sunday
AND `day` >= "2017-04-03" # Monday, start week
AND `active` = 1
GROUP BY `project`, `activity`;
This will result in:
project Activity worked_time
Flubber Specific 03:00:00
Promotion activities 01 Search 01:15:00
Promotion activities Travel 03:00:00
UB Development Development 05:00:00
Work and information Travel 01:30:00
Work and information Symposium 04:30:00
How do I read this result from the database, and display it into my application?
Subject
Written By
Posted
Result query more than one record?
April 09, 2017 05:33AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.