Level 7
For database integrity, I would use many-to-many relationship with proper foreign keys. If you really, really want single column, I'd go with JSON column type (quite new one) or just comma-separated string or anything.
Apr 14, 2016
1
Level 2
Arrays in MySQL?
I am creating a seating chart application. I made a students table, and a chart table. I want to be able to reference students, like have their id in a 'students' column in the chart table. Is there a way that I can put these IDs in an array, so I can call them individually?
NOTE: the students can be in multiple seating charts.
Please or to participate in this conversation.