souad 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.