3 ms·
>Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE. If you're a developer, I would look into CONSTRAINTS way before getting to anything l
by pathseeker 7y ago
>Try looking into SQL functions & TRIGGERs, LATERAL JOINs, ROLLUP & CUBE.
If you're a developer, I would look into CONSTRAINTS way before getting to anything like this. Learning how to model your constraints correctly in the database (preventing duplicates, etc) is one of the most important bits of schema design because it will save you tons of code and likely a bunch of race conditions.