Re: Transpose row into column

[Robert Mann]

I need to normalize a mysql table that has 500 plus fields,and 300 plus records so would like to run a sql statement to extract specific columns of data from this table and create then put it into a new table,

current table name stockvalving
fields to be copied, record_id fcd1qty fcd2qty fcd3qty
data 1 4 3 6

new table name stockvalvingqty

field record_id qty fcdnum
1 4 1
1 3 2
1 6 3


this is just a small number of the fields that need to be moved

Thanks
Rob