MySQL: ON DELETE
#MySQL #tutorial #course
00:00:00 intro
00:02:24 SET NULL
00:04:40 CASCADE
00:07:11 conclusion
ALTER TABLE transactions
ADD CONSTRAINT fk_customer_id
FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
ON DELETE SET NULL;
ALTER TABLE transactions
ADD CONSTRAINT fk_customer_id
FOREIGN KEY (customer_id) REFERENCES customers(customer_id)
ON DELETE CASCADE;
Watch video MySQL: ON DELETE online without registration, duration hours minute second in high quality. This video was added by user Bro Code 21 November 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 21,994 once and liked it 489 people.