How to make Foreign key one-to-many in mysql?

Question

I have a table students and a table courses, my table courses have the course for example of administration, as I relate several students to this table using Foreign key ?

Answer 1

First you create the COURSES Table with the column ID_CURSOS (PRIMARY_KEY), then you create a STUDENTS table with the column ID_ALUNOS (primary_key) and the column ID_CURSO. This column ID_CURSO you point to as FOREGN_KEY having as reference the table COURSES, column ID_CURSOS. Following example:

CREATE TABLE `database`.`cursos` (
  `id_cursos` INT NOT NULL AUTO_INCREMENT,
  `nome_curso` VARCHAR(45) NULL,
  PRIMARY KEY (`id_cursos`));


CREATE TABLE `database`.`alunos` (
  `id_alunos` INT NOT NULL AUTO_INCREMENT,
  `id_curso` INT NULL,
  `nome_aluno` VARCHAR(45) NULL,
  PRIMARY KEY (`id_alunos`),
  INDEX `FK_ALUNO_CURSO_idx` (`id_curso` ASC),
  CONSTRAINT `FK_ALUNO_CURSO` 
    FOREIGN KEY (`id_curso`) 
    REFERENCES `vigilant`.`cursos` (`id_cursos`)
    ON DELETE NO ACTION 
    ON UPDATE NO ACTION);

Any questions just talk. Hugs.