Remix.run Logo
arcanemachiner 7 months 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 7 months ago | parent [-]

It 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