MySQL: ON DELETE

Skip ad
73 Views

  • Thanks! Share it with your friends!

    You disliked this video. Thanks for the feedback!

brocode
Published
#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;
Category
Bro Code
Tags
MySQL tutorial for beginners, SQL tutorial for beginners, MySQL course
Be the first to comment