I have 8 mysql tables of same structure and with same headings. I want to add all corresponding values of all the 8 tables and store them in another 9th table.
Also i need to sum only till the lowest number of row of all the 8 tables.
For Eg. If there are 5 rows in table1 and other 7 have 6 rows each, then i only wamt to add upto 5 rows of all the 8 tables. Kinly provide a solution
I have 8 mysql tables of same structure and with same headings. I want to add all corresponding values of all the 8 tables and store them in another 9th table.
Also i need to sum only till the lowest number of row of all the 8 tables.
For Eg. If there are 5 rows in table1 and other 7 have 6 rows each, then i only wamt to add upto 5 rows of all the 8 tables. Kinly provide a solution.
I am using php with mysql
DHQ DoITC JAIPUR is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.