MySQL Forums

In MySql there is no pivot function.

using a function or Stored Procedure,
I want to loop through a column of data and create a another table that uses the row value as Column labels from the row data.

Example:

table1
a,b,c
chi, 12,xx
nyc,15,xx
atl,16,xx
sf,17,xx,

table2
xx, chi, nyc, atl, sf

then insert data
xx,chic, nyc, atl, sf
t,12,15,16,17