Рет қаралды 7,415
Vincular el campo idSalon de la tabla alumno con el campo id de la tabla salon con la opciones:
cascade
set null
restrict
no action
Codigos:
CASCADE
ALTER TABLE `escuela`.`alumno`
DROP FOREIGN KEY `fk_idSalonNoAccion`;
ALTER TABLE `escuela`.`alumno`
ADD CONSTRAINT `fk_idSalonCascade`
FOREIGN KEY (`idSalon`)
REFERENCES `escuela`.`salon` (`id`)
ON DELETE CASCADE
ON UPDATE CASCADE;
NO ACCION
ALTER TABLE `escuela`.`alumno`
DROP FOREIGN KEY `fk_idSalonNoAccion`;
ALTER TABLE `escuela`.`alumno`
ADD CONSTRAINT `fk_idSalonNoAccion1`
FOREIGN KEY (`idSalon`)
REFERENCES `escuela`.`salon` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION;
RESTRICT
ALTER TABLE `escuela`.`alumno`
DROP FOREIGN KEY `fk_idSalonNoAccion1`;
ALTER TABLE `escuela`.`alumno`
ADD CONSTRAINT `fk_idSalonRestrict`
FOREIGN KEY (`idSalon`)
REFERENCES `escuela`.`salon` (`id`)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
SET NULL
ALTER TABLE `escuela`.`alumno`
DROP FOREIGN KEY `fk_idSalonNoAccion1`;
ALTER TABLE `escuela`.`alumno`
ADD CONSTRAINT `fk_idSalonSetNull`
FOREIGN KEY (`idSalon`)
REFERENCES `escuela`.`salon` (`id`)
ON DELETE SET NULL
ON UPDATE SET NULL;
[CURSO] MYSQL DE 0 A 100🐬: • [CURSO] MYSQL DE 0 A 100🐬
🔗 Facebook: / programadornovatooficial
🔗 Twitter: / programadornova
🔗 Linkedin: / programadornovato
🔗 Instagram: / programadornovato
🔗 Pagina oficial: www.programado...
🔗 Gracias por apoyar este canal: / programadornovato
🎦 Canal de youtube: / programadornovato