Hi,
I have a table with columns like cats,dogs,birds and totalanimal.
It is mainly a database which maintains how many cats,dogs and birds a person has...
what i need is , get the sum of these columns(cats,dogs,birds) and keep the total in totalanimal column...
how do i do this ??
I didn't understand clearly.
- U have 3 tables(cats,dogs,birds) or 4 tables(cats,dogs,birds and totalanimal) ?
- If u have 4 tables and want to get sum value of each column (cats,dogs,birds) and store into totalanimal column, then this not added column but update totalanimal column.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.