Re: Help using MySQL reformatting data

[Phillip Ward]

Good catch.
My query should have selected the column name/header and not the actual value.

Take two:

insert 
into table2 ( state, city, store, sku )
          select state, city, store, 'chocolate_sku' as sku from table1 where chocolate_sku = 1
union all select state, city, store, 'strawberry_sku'       from table1 where strawberry_sku = 1
union all select state, city, store, 'cookiescream_sku'     from table1 where cookiescream_sku = 1

Again, the trick is in creating this query from the given input.

Regards, Phill W.