How to create MySQL table with sub columns?

Asked Mar 18 '21 at 08:53

Active Mar 18 '21 at 09:12

Viewed 16 times

I have a Database Test with this structure.

                          |TABLE|
                      -----------------
                     |ID|  |SONG| |LIKED BY|
                                          .
                                          .
                                          .

What I need is this.

                            |ID|  |SONG|
                                        -|LIKED BY|
                                         (LIST OF LIKERS)
                            |ID|   |SONG|
                                        - |LIKED BY|

Is this possible?

edited Mar 18 '21 at 09:12

Shadow

33,525
10
51
64

asked Mar 18 '21 at 08:53

Abhishek Rai

2,159
3
18
38

1

Use another table of `likers` with a foreign key to the songs table. – Barmar Mar 18 '21 at 08:54
2

Relational databases don't have sub-columns. – Barmar Mar 18 '21 at 08:55
@Barmar Another Table seems to be the way to go. Many Thanks. – Abhishek Rai Mar 18 '21 at 08:56

How to create MySQL table with sub columns?

0 Answers0