CASCADING

 CREATE DATABASE info;

USE info;

CREATE TABLE dept(id INT PRIMARY KEY,name VARCHAR(50));

INSERT INTO dept

VALUES

(123,'cse'),(102,'ece');

SELECT * FROM dept;

UPDATE dept SET id=303 WHERE id=102;

CREATE TABLE teacher(id INT PRIMARY KEY,name VARCHAR(70),dept_id INT ,

FOREIGN KEY (dept_id) REFERENCES dept(id)

ON UPDATE CASCADE

ON DELETE CASCADE);

INSERT INTO teacher

VALUES

(123,'adam',123),(102,'eve',102);

SELECT * FROM teacher;