Such as:

Category 1 100
Category 2 100
Category 1 100-1
Category 1-2 100
Category 2-1 100

Want to use SQL statements classification summary, "class 1", "category 1-1", "category 1-2", "class 2", "category 2-1", consult everybody masters what kind of statement?

Ps: category 1, category 1-1, category 1 or 2 field name irregularly

CodePudding user response:

The field name irregular? Refers to the (category 1 - irregular) like this?

CodePudding user response:

Category 1, category 1-1, category 1 and 2 should not be the field values, the field name is what?

CodePudding user response:

For example, to put "wuhu", "anqing" together into a group, the "huangshan mountain", "hefei" together into a group,

CodePudding user response:

Add a column group id, the same set of id you update into the same
According to the group id group summary again can,