MySQL ranks convert each other

The ranks of each other convert

/*Create a table*/CREATE TABLEIC (NAMEVARCHAR( -), ProductVARCHAR( -), AmountINT);INSERT  intoICVALUES    ('Wang Yi','A1', -),    ('Wang Yi','A3', Max),    ('Wang Yi','A2',Ten),    ('Zhao','A1', the),    ('Zhao','A2', $),    ('Zhao','A3', +),    ('Liu Liu','A1', -),    ('Liu Liu','A2', -),    ('Liu Liu','A3', the);SELECT *  fromIc

To make a column with the value of the product column, the column name becomes NAME,A1,A2,A3.

CREATE TABLEic_1SELECTname,SUM(IF(Product='A1', Amount,0)) asA1,SUM(IF(Product='A2', Amount,0)) asA2,SUM(IF(Product='A3', Amount,0)) asA3 fromICGROUP  byName

If you change the Ic_1 table back to its original appearance

SELECTName'A1'  asProduct, A1 asAmount fromic_1UNIONSELECTName'A2'  asProduct, A2 asAmount fromic_1UNIONSELECTName'A3'  asProduct, A3 asAmount fromic_1ORDER  byName

MySQL ranks convert each other