I have a lookup table that contains 2 columns k_id, keywords as follow
k_id | keywords
1 | hi
2 | play
and so on
I want to create another table using the previous lookup table where I want to put the k_id values as the columns of the other table which it has id attribute only. this is the format
id | 1 | 2 | 3 | 4
and so on. is it possible to create such table I am working on java using mysql.
Please help