dapcigar Posted March 2, 2015 Share Posted March 2, 2015 Dear all, Please i need help with something. I have some data in a particular table called "Requisitions" now i want to sum up all the values in the table by categories and then save it in a table called "transaction log. is there anyway i could achieve this by writing a script that does that automatically for me? thanks in advance Link to comment https://forums.phpfreaks.com/topic/295008-data-manipulation/ Share on other sites More sharing options...
Barand Posted March 2, 2015 Share Posted March 2, 2015 Yes, you could write a single query to do that, but why bother storing data that can be easily derived by the same query. A basic principle of db design - don't store derived data. Link to comment https://forums.phpfreaks.com/topic/295008-data-manipulation/#findComment-1507216 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.