Sample Header Ad - 728x90

How to only allow a boolean to be true if another boolean in the same row is true in MariaDB?

0 votes
2 answers
69 views
I have two boolean columns in my table. One called IsUnlisted and one called IsPrivate. I only want to allow IsPrivate to be 1 (TRUE) if IsUnlisted is 1 (TRUE) as well using a check constraint. I am using MariaDB which shares most things with mysql.
Asked by Garbg (13 rep)
Sep 24, 2024, 10:23 PM
Last activity: Sep 28, 2024, 12:54 AM