MySQL Forums
Forum List  »  PHP

Re: Check Columns and SUM with values ​​from another.
Posted by: Peter Brawley
Date: January 17, 2019 03:48PM

> check the columns ...

What does that mean specifically?

> ... and add up all the defects of each type

If the data are strings as you suggest, you'll need to apply pivot table logic to count instances of specific strings, see "pivot tables" at https://www.artfulsoftware.com/queries.php for discussion and examples.

If you need more help with this, please post info as text rather than as image. (IAC your image link is not functional.)

Options: ReplyQuote


Subject
Written By
Posted
Re: Check Columns and SUM with values ​​from another.
January 17, 2019 03:48PM


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.