Comments - Check constraints support

10 years, 9 months ago txomon

Yes, I think it is still true. If you just want to limit that, you can use a bit field, and save it as 0 or 1.

If not, you would have to use foreign key in that column, to a yes_no_table. (For example).

If you need to make more complex checks, and want to do them through constraints, then you will have to go for another db, like postgresql and so.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.