title: Multiple values in one column MYSQL
body: <p>So I have three databases right now. This is the SQL code the generate each of the tables.</p>
  
  <pre><code>CREATE TABLE `Course` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(25) NOT NULL,
      `startTime` time NOT NULL,
      PRIMARY KEY (`id`)
  );
  
  CREATE TABLE `School` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `schoolname` varchar(25) NOT NULL,
      PRIMARY KEY (`id`)
  );
  
  CREATE TABLE `SchoolCourse` (
      `schoolid` int(11) NOT NULL,
      `courseid` int(11) NOT NULL,
      PRIMARY KEY (`schoolid`,`courseid`),
      KEY `FK_course` (`courseid`),
      CONSTRAINT `FK_course` FOREIGN KEY (`courseid`) REFERENCES `Course` (`id`),
      CONSTRAINT `FK_Student` FOREIGN KEY (`schoolid`) REFERENCES `School` (`id`)
  );
  </code></pre>
  
  <p>My goal with these tables is to make it look something like this</p>
  
  <pre><code>---------------------------------------------------
  |School Name  |          Courses                  |
  ---------------------------------------------------
  | School1     | Course1, Course2, Course3         |
  | School2     | Course1, Course3                  |
  | School3     | Course3                           |
  | School4     | Couse1, Course2, Course3, Course4 |
  ---------------------------------------------------
  </code></pre>
  
  <p>I cant seem to figure out how to do this. I have tried inputting the values like this.</p>
  
  <pre><code>INSERT INTO 'ShcoolCourse' VALUES (
  (1, 1), (1, 2), (1, 3),
  (2, 1), (2, 3),
  (3, 3),
  (4, 1), (4, 2), (4, 3), (4, 4)); 
  </code></pre>
  
  <p>Then from there I would perform a join and try to put the values into one column but no luck so far,
  I have looked around at other question and some of them have the same idea but not exactly what I am
  doing. Any help would be greatly Appreciated.</p>