· 8 years ago · Aug 15, 2018, 08:06 PM
1Using values in a column as field names for new table
2field_id fieldname
31 profile_name
42 profile_surname
55 profile_address_street
6
7profile_name profile_surname profile_address_street
8John Doe Baker Street
9
10create temporary table if not exists newtable(
11 select fieldname from sourcetable
12);