3 ms·
> Though, personally, I would never use ON UPDATE CASCADE, as it seems kind of funky. As a relative noob in the world of database administration, I'm glad to h
by arcanemachiner 2y ago
> Though, personally, I would never use ON UPDATE CASCADE, as it seems kind of funky.
As a relative noob in the world of database administration, I'm glad to hear that someone else feels this way.
- pepelotas 2y agoIt does if your key is an auto increment or random unique identifier. But if you had a key that is also data, say a "Genre" colum, it starts to make sense that you'd want to cascade updates