SQL: Count value une a field

Question

I would like to know if it is possible to have this kind of schema:

Table 1:

Field1 | Field4 | Field3
Field1 | Field4 | Field3 
Field1 | Field4 | Field3

Table 2:

Field4 | Field5(Number of Field3)

To explain the schema, my tables have a similar field, (number4)

And my real question is:

Can I have a dynamic database where the field5 would be the count of field 3 where Table1.field4 = Table2.field4, or should I change it by hand with PHP?

Edit: "Can you provide some example data for this schema? (And perhaps some more meaningful names.)"

Table: prod Product | Description | nbOfreview Product | Description | nbOfreview

Table: Reviews Review | Description | Product

field5 is a derived attribute, is not good practice store attribute that you can derive on the fly. — levi
– levi, Commented Jul 26, 2012 at 2:08
Can you provide some example data for this schema? (And perhaps some more meaningful names.) — user166390
– user166390, Commented Jul 26, 2012 at 2:09
You might want to ask "your real question" first, and add details afterward. My first instinct was to vote to close this as "not a real question". — Ken White
– Ken White, Commented Jul 26, 2012 at 2:20

Chandu · Accepted Answer · 2012-07-26 02:17:16Z

4

You don't need an extra table.
You can use a view.

e.g:

CREATE VIEW v_data AS
SELECT field4, COUNT(field3) F_COUNT
  FROM <YOUR-TABLE>
GROUP BY  field4

answered Jul 26, 2012 at 2:17

Chandu

83.2k19 gold badges137 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL: Count value une a field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related