How to create View in MySQL using rows from second table?

Asked Jul 04 '17 at 07:21

Active Jul 04 '17 at 07:31

Viewed 43 times

I need to create VIEW in MySQL. where each rows from first table should show as column in the second table.

Here is some example:

table Appraisal_skills

    +------------+
    | id |title  | 
    +------------+
    |  1 | TestA | 
    |  2 | TestB | 
    |  3 | TestC |
    |  4 | TestD | 
    +------------+

Required View:

    +--------+------------+-------+
    | TestA| TestB | TestC | testD|
    +----------+------------+------
    |      |       |       |      |
    |      |       |       |      |
    +----------+------------+-----+

Does anybody have an idea how to create view in this way? Any help would be Appreciated.

edited Jul 04 '17 at 07:31

asked Jul 04 '17 at 07:21

Shanu k k

1,235
2
18
43

2

From where will the records `abc, cdf, efg,` etc. come ? – Keyur Panchal Jul 04 '17 at 07:24
2

See this question: https://stackoverflow.com/questions/42876977/ – Usagi Miyamoto Jul 04 '17 at 07:25
Are you sure you want to do this in sql? It's generally best to handle display issues in application code – Strawberry Jul 04 '17 at 07:25
@KeyurPanchal:just dummy values ..i removed it now – Shanu k k Jul 04 '17 at 07:27
@Strawberry:yes i am going to do with using mysql..any other way?please help me – Shanu k k Jul 04 '17 at 07:28
Just google dynamic pivot – Strawberry Jul 04 '17 at 07:31
@Shanukk can you please show us our code please ? or you are just thinking how to do so ? – Bibhudatta Sahoo Jul 04 '17 at 07:31
@Strawberry i google it but haven't found any suitable way forward to create view – Shanu k k Jul 04 '17 at 08:34

How to create View in MySQL using rows from second table?

0 Answers0