如何将数据插入到同一行和列中 - mysql

Question

I'm working on a project using PHP and MySQL. I want to know if I'm able to input multiple amounts of data into the same row and column.

For example:

id       leader_id      student_id
____________________________________
1     |       3      |  1, 2, 3
      |              |

So basically I want the user to input the team leader_id, and then the 3 other team member's ID. Also, I would like to know how I would be able to select each student_id individually.

Answer 1

You could accomplish that but don't. Instead create a record for each leader_id to student_id combination so it will look like the following:

id       leader_id      student_id
____________________________________
1     |       3      |  1
2     |       3      |  2
3     |       3      |  3