Mysql-Mysql stored procedure: collects data in Table A, and generates dynamic columns in Table B (Status Table) data rows.

Table A has A field primary key, ID, name, and evaluation score. Table B has A field primary key, key, and description. the evaluation score corresponds to the key. then Table B is A status table (for example, there are data rows: Satisfied, general, negative rating) current statistics: number, name, (data in the dynamically generated Status Table) satisfaction, general, negative rating, satisfaction rate, general rate, negative rating mysql dynamically generated data storage process

Table A has the primary key, number, name, and evaluation score of the field.
Table B has a field primary key, key, description
Key corresponding to rating score
Then, Table B is a status table (for example, there are data rows: Satisfied, normal, and negative ratings)
Statistics: number, name, (data in the dynamically generated Status Table) satisfaction, average, negative rating, satisfaction rate, general rate, negative rating